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

Line 134: from AME_CONDITIONS,

130: NEW_USE_COUNT := 0;
131: for TEMPRULE in RULE_CURSOR(X_APPLICATION_ID => X_APPLICATION_ID) loop
132: select count(*)
133: into TEMP_COUNT
134: from AME_CONDITIONS,
135: AME_CONDITION_USAGES
136: where
137: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
138: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and

Line 137: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

133: into TEMP_COUNT
134: from AME_CONDITIONS,
135: AME_CONDITION_USAGES
136: where
137: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
138: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
139: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
140: sysdate between AME_CONDITIONS.START_DATE and
141: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and

Line 138: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and

134: from AME_CONDITIONS,
135: AME_CONDITION_USAGES
136: where
137: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
138: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
139: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
140: sysdate between AME_CONDITIONS.START_DATE and
141: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
142: ((sysdate between AME_CONDITION_USAGES.START_DATE and

Line 140: sysdate between AME_CONDITIONS.START_DATE and

136: where
137: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
138: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
139: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
140: sysdate between AME_CONDITIONS.START_DATE and
141: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
142: ((sysdate between AME_CONDITION_USAGES.START_DATE and
143: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
144: (sysdate < AME_CONDITION_USAGES.START_DATE and

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

137: AME_CONDITIONS.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
138: AME_CONDITIONS.CONDITION_ID = AME_CONDITION_USAGES.CONDITION_ID and
139: AME_CONDITION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
140: sysdate between AME_CONDITIONS.START_DATE and
141: nvl(AME_CONDITIONS.END_DATE - (1/86400), sysdate) and
142: ((sysdate between AME_CONDITION_USAGES.START_DATE and
143: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
144: (sysdate < AME_CONDITION_USAGES.START_DATE and
145: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,

Line 228: select AME_CONDITIONS.ATTRIBUTE_ID

224:
225: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type
226: ,X_APPLICATION_ID ame_rule_usages.item_id%type) is
227: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES
231: where
232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,

Line 229: from AME_CONDITIONS,

225: procedure CHANGE_ATTRIBUTE_USAGES_COUNT(X_RULE_ID ame_rule_usages.rule_id%type
226: ,X_APPLICATION_ID ame_rule_usages.item_id%type) is
227: cursor GET_USED_ATTRIBUTES (X_RULE_ID ame_rule_usages.rule_id%type) is
228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES
231: where
232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and

Line 232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,

228: select AME_CONDITIONS.ATTRIBUTE_ID
229: from AME_CONDITIONS,
230: AME_CONDITION_USAGES
231: where
232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
234: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
236: (AME_CONDITIONS.START_DATE <= sysdate and

Line 235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and

231: where
232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
234: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
236: (AME_CONDITIONS.START_DATE <= sysdate and
237: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
238: ((sysdate between AME_CONDITION_USAGES.START_DATE and
239: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 236: (AME_CONDITIONS.START_DATE <= sysdate and

232: AME_CONDITIONS.CONDITION_TYPE in (AME_UTIL.ORDINARYCONDITIONTYPE,
233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
234: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
236: (AME_CONDITIONS.START_DATE <= sysdate and
237: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
238: ((sysdate between AME_CONDITION_USAGES.START_DATE and
239: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
240: (sysdate < AME_CONDITION_USAGES.START_DATE and

Line 237: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and

233: AME_UTIL.EXCEPTIONCONDITIONTYPE) and
234: AME_CONDITION_USAGES.RULE_ID = X_RULE_ID and
235: AME_CONDITION_USAGES.CONDITION_ID = AME_CONDITIONS.CONDITION_ID and
236: (AME_CONDITIONS.START_DATE <= sysdate and
237: (AME_CONDITIONS.END_DATE is null or sysdate < AME_CONDITIONS.END_DATE)) and
238: ((sysdate between AME_CONDITION_USAGES.START_DATE and
239: nvl(AME_CONDITION_USAGES.END_DATE - (1/86400), sysdate)) or
240: (sysdate < AME_CONDITION_USAGES.START_DATE and
241: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,