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_ATTRIBUTE_USAGES_API dependencies on AME_CONDITIONS

Line 44: from AME_CONDITIONS,

40: else
41: for TEMPRULE in RULE_CURSOR(X_APPLICATION_ID => X_APPLICATION_ID) loop
42: select count(*)
43: into TEMP_COUNT
44: from AME_CONDITIONS,
45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID

Line 46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID

42: select count(*)
43: into TEMP_COUNT
44: from AME_CONDITIONS,
45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)

Line 47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID

43: into TEMP_COUNT
44: from AME_CONDITIONS,
45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE

Line 49: and sysdate between AME_CONDITIONS.START_DATE

45: AME_CONDITION_USAGES
46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE

Line 50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)

46: where AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID
47: and AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID
48: and AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID
49: and sysdate between AME_CONDITIONS.START_DATE
50: and nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate)
51: and ((sysdate between AME_CONDITION_USAGES.START_DATE
52: and nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate))
53: or (sysdate < AME_CONDITION_USAGES.START_DATE
54: and AME_CONDITION_USAGES.START_DATE <