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 3780: ame_action_usages

3776: ame_actions.parameter,
3777: ame_actions.parameter_two
3778: from
3779: ame_actions,
3780: ame_action_usages
3781: where
3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and
3784: engEffectiveRuleDate between

Line 3782: ame_actions.action_id = ame_action_usages.action_id and

3778: from
3779: ame_actions,
3780: ame_action_usages
3781: where
3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and
3784: engEffectiveRuleDate between
3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3783: ame_action_usages.rule_id = ruleIdIn and

3779: ame_actions,
3780: ame_action_usages
3781: where
3782: ame_actions.action_id = ame_action_usages.action_id and
3783: ame_action_usages.rule_id = ruleIdIn and
3784: engEffectiveRuleDate between
3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3787: engEffectiveRuleDate between

Line 3788: ame_action_usages.start_date and

3784: engEffectiveRuleDate between
3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3787: engEffectiveRuleDate between
3788: ame_action_usages.start_date and
3789: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);
3790: productionActionTypeId integer;
3791: tempActionTypeIds ame_util.idList;
3792: tempBoolean boolean;

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

3785: ame_actions.start_date and
3786: nvl(ame_actions.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3787: engEffectiveRuleDate between
3788: ame_action_usages.start_date and
3789: nvl(ame_action_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate);
3790: productionActionTypeId integer;
3791: tempActionTypeIds ame_util.idList;
3792: tempBoolean boolean;
3793: tempNewRuleIndex integer;

Line 4406: ame_action_usages,

4402: union
4403: select 1
4404: from ame_mandatory_attributes,
4405: ame_actions,
4406: ame_action_usages,
4407: ame_rules,
4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =

Line 4412: and ame_actions.action_id = ame_action_usages.action_id

4408: ame_rule_usages
4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date

Line 4413: and ame_action_usages.rule_id = ame_rules.rule_id

4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id
4410: and ame_mandatory_attributes.action_type_id =
4411: ame_actions.action_type_id
4412: and ame_actions.action_id = ame_action_usages.action_id
4413: and ame_action_usages.rule_id = ame_rules.rule_id
4414: and ame_rules.rule_id = ame_rule_usages.rule_id
4415: and ame_rule_usages.item_id = applicationIdIn
4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))

Line 4424: and ((engEffectiveRuleDate between ame_action_usages.start_date

4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date
4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4422: and engEffectiveRuleDate between ame_actions.start_date
4423: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)
4424: and ((engEffectiveRuleDate between ame_action_usages.start_date
4425: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))
4426: )
4427: /*
4428: The order-by conditions are all necessary. The second is to break

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

4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)
4422: and engEffectiveRuleDate between ame_actions.start_date
4423: and nvl(ame_actions.end_date - (1/86400), engEffectiveRuleDate)
4424: and ((engEffectiveRuleDate between ame_action_usages.start_date
4425: and nvl(ame_action_usages.end_date - (1/86400), engEffectiveRuleDate)))
4426: )
4427: /*
4428: The order-by conditions are all necessary. The second is to break
4429: item_class_order_number ties in a determinate order. The third is