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_MANDATORY_ATTRIBUTES

Line 155: AME_MANDATORY_ATTRIBUTES,

151: -- action_id is already migrated from ame_rules to ame_action_usages
152: select count(*)
153: into TEMP_COUNT
154: from
155: AME_MANDATORY_ATTRIBUTES,
156: AME_ACTIONS,
157: AME_ACTION_USAGES
158: where
159: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

Line 159: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

155: AME_MANDATORY_ATTRIBUTES,
156: AME_ACTIONS,
157: AME_ACTION_USAGES
158: where
159: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
160: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
161: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
162: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
163: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

Line 160: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

156: AME_ACTIONS,
157: AME_ACTION_USAGES
158: where
159: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
160: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
161: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
162: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
163: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
164: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 163: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

159: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
160: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
161: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
162: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
163: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
164: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
165: sysdate between AME_ACTIONS.START_DATE and
166: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
167: ((sysdate between AME_ACTION_USAGES.START_DATE and

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

160: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
161: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
162: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
163: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
164: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
165: sysdate between AME_ACTIONS.START_DATE and
166: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
167: ((sysdate between AME_ACTION_USAGES.START_DATE and
168: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 176: AME_MANDATORY_ATTRIBUTES,

172: else
173: select count(*)
174: into TEMP_COUNT
175: from
176: AME_MANDATORY_ATTRIBUTES,
177: AME_ACTIONS,
178: AME_RULES
179: where
180: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

Line 180: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

176: AME_MANDATORY_ATTRIBUTES,
177: AME_ACTIONS,
178: AME_RULES
179: where
180: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
181: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
182: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
183: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
184: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

Line 181: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

177: AME_ACTIONS,
178: AME_RULES
179: where
180: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
181: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
182: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
183: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
184: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
185: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 184: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

180: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
181: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
182: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
183: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
184: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
185: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
186: sysdate between AME_ACTIONS.START_DATE and
187: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
188: ((sysdate between AME_RULES.START_DATE and

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

181: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
182: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
183: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
184: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
185: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
186: sysdate between AME_ACTIONS.START_DATE and
187: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
188: ((sysdate between AME_RULES.START_DATE and
189: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or

Line 244: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

240: (sysdate < AME_CONDITION_USAGES.START_DATE and
241: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
242: AME_CONDITION_USAGES.START_DATE + (1/86400))))
243: union
244: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
245: from AME_MANDATORY_ATTRIBUTES,
246: AME_ACTION_USAGES,
247: AME_ACTIONS
248: where

Line 245: from AME_MANDATORY_ATTRIBUTES,

241: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
242: AME_CONDITION_USAGES.START_DATE + (1/86400))))
243: union
244: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
245: from AME_MANDATORY_ATTRIBUTES,
246: AME_ACTION_USAGES,
247: AME_ACTIONS
248: where
249: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 249: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

245: from AME_MANDATORY_ATTRIBUTES,
246: AME_ACTION_USAGES,
247: AME_ACTIONS
248: where
249: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
250: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
251: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
252: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
253: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

Line 252: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

248: where
249: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
250: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
251: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
252: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
253: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
254: ((sysdate between AME_ACTION_USAGES.START_DATE and
255: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
256: (sysdate < AME_ACTION_USAGES.START_DATE and

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

249: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
250: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
251: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
252: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
253: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
254: ((sysdate between AME_ACTION_USAGES.START_DATE and
255: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or
256: (sysdate < AME_ACTION_USAGES.START_DATE and
257: AME_ACTION_USAGES.START_DATE < nvl(AME_ACTION_USAGES.END_DATE,AME_ACTION_USAGES.START_DATE

Line 262: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

258: + (1/86400)))) and
259: (AME_ACTIONS.START_DATE <= sysdate and
260: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
261: union
262: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
263: from AME_MANDATORY_ATTRIBUTES,
264: AME_RULES,
265: AME_ACTIONS
266: where

Line 263: from AME_MANDATORY_ATTRIBUTES,

259: (AME_ACTIONS.START_DATE <= sysdate and
260: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
261: union
262: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
263: from AME_MANDATORY_ATTRIBUTES,
264: AME_RULES,
265: AME_ACTIONS
266: where
267: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 267: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

263: from AME_MANDATORY_ATTRIBUTES,
264: AME_RULES,
265: AME_ACTIONS
266: where
267: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
268: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
269: AME_RULES.ACTION_ID is not null and
270: AME_RULES.RULE_ID = X_RULE_ID and
271: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

Line 271: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

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

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

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