eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_RULE_USAGES_API2 dependencies on FND_APPLICATION_VL

Line 30: FND_APPLICATION_VL FA

26: X_TRANSACTION_TYPE_ID in VARCHAR2
27: ) is
28: select ACA.APPLICATION_ID
29: from AME_CALLING_APPS ACA,
30: FND_APPLICATION_VL FA
31: where FA.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
32: and nvl(ACA.TRANSACTION_TYPE_ID,'NULL') = nvl(X_TRANSACTION_TYPE_ID,'NULL')
33: and FA.APPLICATION_ID = ACA.FND_APPLICATION_ID
34: and sysdate between ACA.START_DATE

Line 102: FND_APPLICATION_VL FA

98: X_TRANSACTION_TYPE_ID in VARCHAR2
99: ) is
100: select ACA.APPLICATION_ID
101: from AME_CALLING_APPS ACA,
102: FND_APPLICATION_VL FA
103: where FA.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
104: and nvl(ACA.TRANSACTION_TYPE_ID,'NULL') = nvl(X_TRANSACTION_TYPE_ID,'NULL')
105: and FA.APPLICATION_ID = ACA.FND_APPLICATION_ID
106: and ((ACA.START_DATE - (1/86400)) <= sysdate)