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 AME_MANDATORY_ATTRIBUTES

Line 187: AME_MANDATORY_ATTRIBUTES,

183: -- action_id is already migrated from ame_rules to ame_action_usages
184: select count(*)
185: into TEMP_COUNT
186: from
187: AME_MANDATORY_ATTRIBUTES,
188: AME_ACTIONS,
189: AME_ACTION_USAGES
190: where
191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

Line 191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

187: AME_MANDATORY_ATTRIBUTES,
188: AME_ACTIONS,
189: AME_ACTION_USAGES
190: where
191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

Line 192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

188: AME_ACTIONS,
189: AME_ACTION_USAGES
190: where
191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
196: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

191: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
196: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
197: sysdate between AME_ACTIONS.START_DATE and
198: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
199: ((sysdate between AME_ACTION_USAGES.START_DATE and

Line 196: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

192: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
193: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
194: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
195: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
196: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
197: sysdate between AME_ACTIONS.START_DATE and
198: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
199: ((sysdate between AME_ACTION_USAGES.START_DATE and
200: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 208: AME_MANDATORY_ATTRIBUTES,

204: else
205: select count(*)
206: into TEMP_COUNT
207: from
208: AME_MANDATORY_ATTRIBUTES,
209: AME_ACTIONS,
210: AME_RULES
211: where
212: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

Line 212: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

208: AME_MANDATORY_ATTRIBUTES,
209: AME_ACTIONS,
210: AME_RULES
211: where
212: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
213: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
214: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
215: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
216: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

Line 213: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

209: AME_ACTIONS,
210: AME_RULES
211: where
212: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
213: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
214: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
215: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
216: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
217: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 216: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

212: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
213: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
214: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
215: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
216: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
217: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
218: sysdate between AME_ACTIONS.START_DATE and
219: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
220: ((sysdate between AME_RULES.START_DATE and

Line 217: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

213: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
214: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
215: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
216: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
217: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
218: sysdate between AME_ACTIONS.START_DATE and
219: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
220: ((sysdate between AME_RULES.START_DATE and
221: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or

Line 261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

257: (sysdate < AME_CONDITION_USAGES.START_DATE and
258: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union
261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
262: from AME_MANDATORY_ATTRIBUTES,
263: AME_ACTION_USAGES,
264: AME_ACTIONS
265: where

Line 262: from AME_MANDATORY_ATTRIBUTES,

258: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
259: AME_CONDITION_USAGES.START_DATE + (1/86400))))
260: union
261: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
262: from AME_MANDATORY_ATTRIBUTES,
263: AME_ACTION_USAGES,
264: AME_ACTIONS
265: where
266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

262: from AME_MANDATORY_ATTRIBUTES,
263: AME_ACTION_USAGES,
264: AME_ACTIONS
265: where
266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

Line 269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

265: where
266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
273: (sysdate < AME_ACTION_USAGES.START_DATE and

Line 270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

266: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
267: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
268: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
269: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
270: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
271: ((sysdate between AME_ACTION_USAGES.START_DATE and
272: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
273: (sysdate < AME_ACTION_USAGES.START_DATE and
274: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE

Line 279: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

275: + (1/86400)))) and
276: (AME_ACTIONS.START_DATE <= sysdate and
277: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
278: union
279: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
280: from AME_MANDATORY_ATTRIBUTES,
281: AME_RULES,
282: AME_ACTIONS
283: where

Line 280: from AME_MANDATORY_ATTRIBUTES,

276: (AME_ACTIONS.START_DATE <= sysdate and
277: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
278: union
279: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
280: from AME_MANDATORY_ATTRIBUTES,
281: AME_RULES,
282: AME_ACTIONS
283: where
284: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 284: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

280: from AME_MANDATORY_ATTRIBUTES,
281: AME_RULES,
282: AME_ACTIONS
283: where
284: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
285: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
286: AME_RULES.ACTION_ID is not null and
287: AME_RULES.RULE_ID = X_RULE_ID and
288: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

Line 288: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

284: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
285: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
286: AME_RULES.ACTION_ID is not null and
287: AME_RULES.RULE_ID = X_RULE_ID and
288: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
289: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
290: ((sysdate between AME_RULES.START_DATE and
291: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
292: (sysdate < AME_RULES.START_DATE and

Line 289: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

285: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
286: AME_RULES.ACTION_ID is not null and
287: AME_RULES.RULE_ID = X_RULE_ID and
288: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
289: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
290: ((sysdate between AME_RULES.START_DATE and
291: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
292: (sysdate < AME_RULES.START_DATE and
293: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,AME_RULES.START_DATE