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_ENGINE dependencies on AME_ACTION_USAGES

Line 3820: ame_action_usages

3816: ame_actions.parameter,
3817: ame_actions.parameter_two
3818: from
3819: ame_actions,
3820: ame_action_usages
3821: where
3822: ame_actions.action_id = ame_action_usages.action_id and
3823: ame_action_usages.rule_id = ruleIdIn and
3824: engEffectiveRuleDate between

Line 3822: ame_actions.action_id = ame_action_usages.action_id and

3818: from
3819: ame_actions,
3820: ame_action_usages
3821: where
3822: ame_actions.action_id = ame_action_usages.action_id and
3823: ame_action_usages.rule_id = ruleIdIn and
3824: engEffectiveRuleDate between
3825: ame_actions.start_date and
3826: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3823: ame_action_usages.rule_id = ruleIdIn and

3819: ame_actions,
3820: ame_action_usages
3821: where
3822: ame_actions.action_id = ame_action_usages.action_id and
3823: ame_action_usages.rule_id = ruleIdIn and
3824: engEffectiveRuleDate between
3825: ame_actions.start_date and
3826: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3827: engEffectiveRuleDate between

Line 3828: ame_action_usages.start_date and

3824: engEffectiveRuleDate between
3825: ame_actions.start_date and
3826: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3827: engEffectiveRuleDate between
3828: ame_action_usages.start_date and
3829: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);
3830: productionActionTypeId integer;
3831: tempActionTypeIds ame_util.idList;
3832: tempBoolean boolean;

Line 3829: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);

3825: ame_actions.start_date and
3826: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3827: engEffectiveRuleDate between
3828: ame_action_usages.start_date and
3829: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);
3830: productionActionTypeId integer;
3831: tempActionTypeIds ame_util.idList;
3832: tempBoolean boolean;
3833: tempNewRuleIndex integer;

Line 4446: ame_action_usages,

4442: union
4443: select 1
4444: from ame_mandatory_attributes,
4445: ame_actions,
4446: ame_action_usages,
4447: ame_rules,
4448: ame_rule_usages
4449: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4450: and ame_mandatory_attributes.action_type_id =

Line 4452: and ame_actions.action_id = ame_action_usages.action_id

4448: ame_rule_usages
4449: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4450: and ame_mandatory_attributes.action_type_id =
4451: ame_actions.action_type_id
4452: and ame_actions.action_id = ame_action_usages.action_id
4453: and ame_action_usages.rule_id = ame_rules.rule_id
4454: and ame_rules.rule_id = ame_rule_usages.rule_id
4455: and ame_rule_usages.item_id = applicationIdIn
4456: and ((engEffectiveRuleDate between ame_rules.start_date

Line 4453: and ame_action_usages.rule_id = ame_rules.rule_id

4449: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4450: and ame_mandatory_attributes.action_type_id =
4451: ame_actions.action_type_id
4452: and ame_actions.action_id = ame_action_usages.action_id
4453: and ame_action_usages.rule_id = ame_rules.rule_id
4454: and ame_rules.rule_id = ame_rule_usages.rule_id
4455: and ame_rule_usages.item_id = applicationIdIn
4456: and ((engEffectiveRuleDate between ame_rules.start_date
4457: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4464: and ((engEffectiveRuleDate between ame_action_usages.start_date

4460: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4461: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4462: and engEffectiveRuleDate between ame_actions.start_date
4463: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)
4464: and ((engEffectiveRuleDate between ame_action_usages.start_date
4465: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))
4466: )
4467: /*
4468: The order-by conditions are all necessary. The second is to break

Line 4465: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))

4461: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4462: and engEffectiveRuleDate between ame_actions.start_date
4463: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)
4464: and ((engEffectiveRuleDate between ame_action_usages.start_date
4465: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))
4466: )
4467: /*
4468: The order-by conditions are all necessary. The second is to break
4469: item_class_order_number ties in a determinate order. The third is