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_ACTIONS

Line 65: AME_ACTIONS,

61: -- action_id is already migrated from ame_rules to ame_action_usages
62: select count(*)
63: into TEMP_COUNT
64: from AME_MANDATORY_ATTRIBUTES,
65: AME_ACTIONS,
66: AME_ACTION_USAGES
67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
69: AME_ACTIONS.ACTION_TYPE_ID

Line 69: AME_ACTIONS.ACTION_TYPE_ID

65: AME_ACTIONS,
66: AME_ACTION_USAGES
67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
69: AME_ACTIONS.ACTION_TYPE_ID
70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)

Line 70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID

66: AME_ACTION_USAGES
67: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
68: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
69: AME_ACTIONS.ACTION_TYPE_ID
70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE

Line 74: and sysdate between AME_ACTIONS.START_DATE

70: and AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID
71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE
75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE

Line 75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)

71: and AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID
72: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
73: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
74: and sysdate between AME_ACTIONS.START_DATE
75: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
76: and ((sysdate between AME_ACTION_USAGES.START_DATE
77: and nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate))
78: or (sysdate < AME_ACTION_USAGES.START_DATE
79: and AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,

Line 86: AME_ACTIONS,

82: -- action_id is yet to be migrated from ame_rules to ame_action_usages
83: select count(*)
84: into TEMP_COUNT
85: from AME_MANDATORY_ATTRIBUTES,
86: AME_ACTIONS,
87: AME_RULES
88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
90: AME_ACTIONS.ACTION_TYPE_ID

Line 90: AME_ACTIONS.ACTION_TYPE_ID

86: AME_ACTIONS,
87: AME_RULES
88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
90: AME_ACTIONS.ACTION_TYPE_ID
91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)

Line 91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID

87: AME_RULES
88: where AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID
89: and AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID =
90: AME_ACTIONS.ACTION_TYPE_ID
91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
95: and sysdate between AME_ACTIONS.START_DATE

Line 95: and sysdate between AME_ACTIONS.START_DATE

91: and AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID
92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
95: and sysdate between AME_ACTIONS.START_DATE
96: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
97: and ((sysdate between AME_RULES.START_DATE
98: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
99: or (sysdate < AME_RULES.START_DATE

Line 96: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)

92: and AME_RULES.RULE_ID = TEMPRULE.RULE_ID
93: and sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE
94: and nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate)
95: and sysdate between AME_ACTIONS.START_DATE
96: and nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate)
97: and ((sysdate between AME_RULES.START_DATE
98: and nvl(AME_RULES.END_DATE - (1/86400), sysdate))
99: or (sysdate < AME_RULES.START_DATE
100: and AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,