Important Queries Using in OAF
To get Application Short Name
select fa.APPLICATION_SHORT_NAME from fnd_application fa,FND_RESPONSIBILITY_TL fr where fa.APPLICATION_ID=fr.APPLICATION_ID and fr.RESPONSIBILITY_NAME='Purchasing, Vision Operations (USA)'
select fa.APPLICATION_SHORT_NAME from fnd_application fa,FND_RESPONSIBILITY_TL fr where fa.APPLICATION_ID=fr.APPLICATION_ID and fr.RESPONSIBILITY_NAME='Purchasing, Vision Operations (USA)'
No comments:
Post a Comment