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_ACTIONS

Line 126: ame_actions,

122: select count(*)
123: into tempCount
124: from
125: ame_mandatory_attributes,
126: ame_actions,
127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

Line 130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

126: ame_actions,
127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 131: ame_actions.action_id = ame_action_usages.action_id and

127: ame_action_usages
128: where
129: ame_mandatory_attributes.attribute_id = attributeIdIn and
130: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and

Line 135: sysdate between ame_actions.start_date and

131: ame_actions.action_id = ame_action_usages.action_id and
132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and

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

132: ame_action_usages.rule_id = tempRule.rule_id and
133: sysdate between ame_mandatory_attributes.start_date and
134: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
135: sysdate between ame_actions.start_date and
136: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
137: ((sysdate between ame_action_usages.start_date and
138: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
139: (sysdate < ame_action_usages.start_date and
140: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

Line 3692: ame_actions,

3688: /* the distinct is necessary because of the possibility that multiple rules
3689: within an application will use the specified approval type */
3690: select distinct ame_rule_usages.item_id
3691: from ame_action_usages,
3692: ame_actions,
3693: ame_rule_usages
3694: where
3695: ame_action_usages.action_id = ame_actions.action_id and
3696: ame_action_usages.rule_id = ame_rule_usages.rule_id and

Line 3695: ame_action_usages.action_id = ame_actions.action_id and

3691: from ame_action_usages,
3692: ame_actions,
3693: ame_rule_usages
3694: where
3695: ame_action_usages.action_id = ame_actions.action_id and
3696: ame_action_usages.rule_id = ame_rule_usages.rule_id and
3697: ame_actions.action_type_id = actionTypeIdIn and
3698: ((sysdate between ame_action_usages.start_date and
3699: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 3697: ame_actions.action_type_id = actionTypeIdIn and

3693: ame_rule_usages
3694: where
3695: ame_action_usages.action_id = ame_actions.action_id and
3696: ame_action_usages.rule_id = ame_rule_usages.rule_id and
3697: ame_actions.action_type_id = actionTypeIdIn and
3698: ((sysdate between ame_action_usages.start_date and
3699: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3700: (sysdate < ame_action_usages.start_date and
3701: ame_action_usages.start_date < nvl(ame_action_usages.end_date,

Line 3703: ( sysdate between ame_actions.start_date and

3699: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
3700: (sysdate < ame_action_usages.start_date and
3701: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3702: ame_action_usages.start_date + ame_util.oneSecond))) and
3703: ( sysdate between ame_actions.start_date and
3704: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) ) and
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and

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

3700: (sysdate < ame_action_usages.start_date and
3701: ame_action_usages.start_date < nvl(ame_action_usages.end_date,
3702: ame_action_usages.start_date + ame_util.oneSecond))) and
3703: ( sysdate between ame_actions.start_date and
3704: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) ) and
3705: ((sysdate between ame_rule_usages.start_date and
3706: nvl(ame_rule_usages.end_date - ame_util.oneSecond, sysdate)) or
3707: (sysdate < ame_rule_usages.start_date and
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,