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

Line 822: ame_condition_usages

818: select count(*)
819: into tempCount
820: from
821: ame_conditions,
822: ame_condition_usages
823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and

Line 825: ame_conditions.condition_id = ame_condition_usages.condition_id and

821: ame_conditions,
822: ame_condition_usages
823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and

Line 826: ame_condition_usages.rule_id = tempRule.rule_id and

822: ame_condition_usages
823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 829: ((sysdate between ame_condition_usages.start_date and

825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));

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

826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));
834: if(tempCount > 0) then

Line 831: (sysdate < ame_condition_usages.start_date and

827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));
834: if(tempCount > 0) then
835: useCount := useCount + 1;

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

828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));
834: if(tempCount > 0) then
835: useCount := useCount + 1;
836: else

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

829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
833: ame_condition_usages.start_date + ame_util.oneSecond)));
834: if(tempCount > 0) then
835: useCount := useCount + 1;
836: else
837: select count(*)