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_PKG dependencies on AME_CONDITION_USAGES

Line 107: ame_condition_usages

103: select count(*)
104: into tempCount
105: from
106: ame_conditions,
107: ame_condition_usages
108: where
109: ame_conditions.attribute_id = attributeIdIn and
110: ame_conditions.condition_id = ame_condition_usages.condition_id and
111: ame_condition_usages.rule_id = tempRule.rule_id and

Line 110: ame_conditions.condition_id = ame_condition_usages.condition_id and

106: ame_conditions,
107: ame_condition_usages
108: where
109: ame_conditions.attribute_id = attributeIdIn and
110: ame_conditions.condition_id = ame_condition_usages.condition_id and
111: ame_condition_usages.rule_id = tempRule.rule_id and
112: sysdate between ame_conditions.start_date and
113: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
114: ((sysdate between ame_condition_usages.start_date and

Line 111: ame_condition_usages.rule_id = tempRule.rule_id and

107: ame_condition_usages
108: where
109: ame_conditions.attribute_id = attributeIdIn and
110: ame_conditions.condition_id = ame_condition_usages.condition_id and
111: ame_condition_usages.rule_id = tempRule.rule_id and
112: sysdate between ame_conditions.start_date and
113: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
114: ((sysdate between ame_condition_usages.start_date and
115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 114: ((sysdate between ame_condition_usages.start_date and

110: ame_conditions.condition_id = ame_condition_usages.condition_id and
111: ame_condition_usages.rule_id = tempRule.rule_id and
112: sysdate between ame_conditions.start_date and
113: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
114: ((sysdate between ame_condition_usages.start_date and
115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
116: (sysdate < ame_condition_usages.start_date and
117: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
118: ame_condition_usages.start_date + ame_util.oneSecond)));

Line 115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

111: ame_condition_usages.rule_id = tempRule.rule_id and
112: sysdate between ame_conditions.start_date and
113: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
114: ((sysdate between ame_condition_usages.start_date and
115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
116: (sysdate < ame_condition_usages.start_date and
117: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
118: ame_condition_usages.start_date + ame_util.oneSecond)));
119: if(tempCount > 0) then

Line 116: (sysdate < ame_condition_usages.start_date and

112: sysdate between ame_conditions.start_date and
113: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
114: ((sysdate between ame_condition_usages.start_date and
115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
116: (sysdate < ame_condition_usages.start_date and
117: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
118: ame_condition_usages.start_date + ame_util.oneSecond)));
119: if(tempCount > 0) then
120: useCount := useCount + 1;

Line 117: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

113: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
114: ((sysdate between ame_condition_usages.start_date and
115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
116: (sysdate < ame_condition_usages.start_date and
117: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
118: ame_condition_usages.start_date + ame_util.oneSecond)));
119: if(tempCount > 0) then
120: useCount := useCount + 1;
121: else

Line 118: ame_condition_usages.start_date + ame_util.oneSecond)));

114: ((sysdate between ame_condition_usages.start_date and
115: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
116: (sysdate < ame_condition_usages.start_date and
117: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
118: ame_condition_usages.start_date + ame_util.oneSecond)));
119: if(tempCount > 0) then
120: useCount := useCount + 1;
121: else
122: select count(*)

Line 267: ame_condition_usages

263: into attributeConditionInUseCnt
264: from ame_attributes,
265: ame_conditions,
266: ame_rules,
267: ame_condition_usages
268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and

Line 270: ame_conditions.condition_id = ame_condition_usages.condition_id and

266: ame_rules,
267: ame_condition_usages
268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and

Line 271: ame_rules.rule_id = ame_condition_usages.rule_id and

267: ame_condition_usages
268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and

Line 279: ((sysdate between ame_condition_usages.start_date and

275: sysdate between ame_attributes.start_date and
276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
277: sysdate between ame_conditions.start_date and
278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and
280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and

Line 280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
277: sysdate between ame_conditions.start_date and
278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and
280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and

Line 281: (sysdate < ame_condition_usages.start_date and

277: sysdate between ame_conditions.start_date and
278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and
280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or

Line 282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,

278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and
280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and

Line 283: ame_condition_usages.start_date + ame_util.oneSecond))) and

279: ((sysdate between ame_condition_usages.start_date and
280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
281: (sysdate < ame_condition_usages.start_date and
282: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
283: ame_condition_usages.start_date + ame_util.oneSecond))) and
284: ((sysdate between ame_rules.start_date and
285: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
286: (sysdate < ame_rules.start_date and
287: ame_rules.start_date < nvl(ame_rules.end_date,