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_ACTIONS

Line 841: ame_actions,

837: select count(*)
838: into tempCount
839: from
840: ame_mandatory_attributes,
841: ame_actions,
842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

Line 845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

841: ame_actions,
842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 846: ame_actions.action_id = ame_action_usages.action_id and

842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and

Line 850: sysdate between ame_actions.start_date and

846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and

Line 851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and

847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
854: (sysdate < ame_action_usages.start_date and
855: ame_action_usages.start_date < nvl(ame_action_usages.end_date,