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_API dependencies on AME_MANDATORY_ATTRIBUTES

Line 114: AME_MANDATORY_ATTRIBUTES,

110: -- action_id is already migrated from ame_rules to ame_action_usages
111: select count(*)
112: into TEMP_COUNT
113: from
114: AME_MANDATORY_ATTRIBUTES,
115: AME_ACTIONS,
116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

Line 118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

114: AME_MANDATORY_ATTRIBUTES,
115: AME_ACTIONS,
116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

Line 119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

115: AME_ACTIONS,
116: AME_ACTION_USAGES
117: where
118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

118: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and

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

119: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
120: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
121: AME_ACTION_USAGES.RULE_ID = TEMPRULE.RULE_ID and
122: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
123: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
124: sysdate between AME_ACTIONS.START_DATE and
125: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
126: ((sysdate between AME_ACTION_USAGES.START_DATE and
127: nvl(AME_ACTION_USAGES.END_DATE - (1/86400), sysdate)) or

Line 135: AME_MANDATORY_ATTRIBUTES,

131: else
132: select count(*)
133: into TEMP_COUNT
134: from
135: AME_MANDATORY_ATTRIBUTES,
136: AME_ACTIONS,
137: AME_RULES
138: where
139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

Line 139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and

135: AME_MANDATORY_ATTRIBUTES,
136: AME_ACTIONS,
137: AME_RULES
138: where
139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

Line 140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

136: AME_ACTIONS,
137: AME_RULES
138: where
139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and

Line 143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and

139: AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID = X_ATTRIBUTE_ID and
140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
145: sysdate between AME_ACTIONS.START_DATE and
146: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
147: ((sysdate between AME_RULES.START_DATE and

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

140: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
141: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
142: AME_RULES.RULE_ID = TEMPRULE.RULE_ID and
143: sysdate between AME_MANDATORY_ATTRIBUTES.START_DATE and
144: nvl(AME_MANDATORY_ATTRIBUTES.END_DATE - (1/86400), sysdate) and
145: sysdate between AME_ACTIONS.START_DATE and
146: nvl(AME_ACTIONS.END_DATE - (1/86400), sysdate) and
147: ((sysdate between AME_RULES.START_DATE and
148: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or

Line 188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

184: (sysdate < AME_CONDITION_USAGES.START_DATE and
185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where

Line 189: from AME_MANDATORY_ATTRIBUTES,

185: AME_CONDITION_USAGES.START_DATE < nvl(AME_CONDITION_USAGES.END_DATE,
186: AME_CONDITION_USAGES.START_DATE + (1/86400))))
187: union
188: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

189: from AME_MANDATORY_ATTRIBUTES,
190: AME_ACTION_USAGES,
191: AME_ACTIONS
192: where
193: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
194: AME_ACTIONS.ACTION_ID = AME_ACTION_USAGES.ACTION_ID and
195: AME_ACTION_USAGES.RULE_ID = X_RULE_ID and
196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
197: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and

Line 196: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

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

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

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

Line 206: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID

202: + (1/86400)))) and
203: (AME_ACTIONS.START_DATE <= sysdate and
204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
205: union
206: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
207: from AME_MANDATORY_ATTRIBUTES,
208: AME_RULES,
209: AME_ACTIONS
210: where

Line 207: from AME_MANDATORY_ATTRIBUTES,

203: (AME_ACTIONS.START_DATE <= sysdate and
204: (AME_ACTIONS.END_DATE is null or sysdate < AME_ACTIONS.END_DATE))
205: union
206: select AME_MANDATORY_ATTRIBUTES.ATTRIBUTE_ID
207: from AME_MANDATORY_ATTRIBUTES,
208: AME_RULES,
209: AME_ACTIONS
210: where
211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

Line 211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and

207: from AME_MANDATORY_ATTRIBUTES,
208: AME_RULES,
209: AME_ACTIONS
210: where
211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
213: AME_RULES.ACTION_ID is not null and
214: AME_RULES.RULE_ID = X_RULE_ID and
215: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

Line 215: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and

211: AME_MANDATORY_ATTRIBUTES.ACTION_TYPE_ID = AME_ACTIONS.ACTION_TYPE_ID and
212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
213: AME_RULES.ACTION_ID is not null and
214: AME_RULES.RULE_ID = X_RULE_ID and
215: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
216: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
217: ((sysdate between AME_RULES.START_DATE and
218: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
219: (sysdate < AME_RULES.START_DATE and

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

212: AME_ACTIONS.ACTION_ID = AME_RULES.ACTION_ID and
213: AME_RULES.ACTION_ID is not null and
214: AME_RULES.RULE_ID = X_RULE_ID and
215: (AME_MANDATORY_ATTRIBUTES.START_DATE <= sysdate and
216: (AME_MANDATORY_ATTRIBUTES.END_DATE is null or sysdate < AME_MANDATORY_ATTRIBUTES.END_DATE)) and
217: ((sysdate between AME_RULES.START_DATE and
218: nvl(AME_RULES.END_DATE - (1/86400), sysdate)) or
219: (sysdate < AME_RULES.START_DATE and
220: AME_RULES.START_DATE < nvl(AME_RULES.END_DATE,AME_RULES.START_DATE