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_MANDATORY_ATTRIBUTES

Line 3938: ame_mandatory_attributes

3934: ame_attributes.attribute_id in
3935: (select ame_attributes2.attribute_id
3936: from
3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes
3939: where
3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and
3942: engEffectiveRuleDate between

Line 3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and

3936: from
3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes
3939: where
3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and
3942: engEffectiveRuleDate between
3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3941: ame_mandatory_attributes.action_type_id = -1 and

3937: ame_attributes ame_attributes2,
3938: ame_mandatory_attributes
3939: where
3940: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
3941: ame_mandatory_attributes.action_type_id = -1 and
3942: engEffectiveRuleDate between
3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3945: engEffectiveRuleDate between

Line 3946: ame_mandatory_attributes.start_date and

3942: engEffectiveRuleDate between
3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3945: engEffectiveRuleDate between
3946: ame_mandatory_attributes.start_date and
3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3948: engEffectiveRuleDate between
3949: ame_attributes.start_date and
3950: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and

3943: ame_attributes2.start_date and
3944: nvl(ame_attributes2.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3945: engEffectiveRuleDate between
3946: ame_mandatory_attributes.start_date and
3947: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate))) and
3948: engEffectiveRuleDate between
3949: ame_attributes.start_date and
3950: nvl(ame_attributes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
3951: engEffectiveRuleDate between

Line 4362: ame_mandatory_attributes

4358: ame_attributes.attribute_id not in
4359: (select ame_attributes2.attribute_id
4360: from
4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes
4363: where
4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and
4366: sysdate between

Line 4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and

4360: from
4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes
4363: where
4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and
4366: sysdate between
4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and

Line 4365: ame_mandatory_attributes.action_type_id = -1 and

4361: ame_attributes ame_attributes2,
4362: ame_mandatory_attributes
4363: where
4364: ame_attributes2.attribute_id = ame_mandatory_attributes.attribute_id and
4365: ame_mandatory_attributes.action_type_id = -1 and
4366: sysdate between
4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4369: sysdate between

Line 4370: ame_mandatory_attributes.start_date and

4366: sysdate between
4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4369: sysdate between
4370: ame_mandatory_attributes.start_date and
4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4372: sysdate between
4373: ame_attributes.start_date and
4374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and

4367: ame_attributes2.start_date and
4368: nvl(ame_attributes2.end_date - ame_util.oneSecond, sysdate) and
4369: sysdate between
4370: ame_mandatory_attributes.start_date and
4371: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate))) and
4372: sysdate between
4373: ame_attributes.start_date and
4374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
4375: sysdate between

Line 4404: from ame_mandatory_attributes,

4400: and ((engEffectiveRuleDate between ame_condition_usages.start_date
4401: and nvl(ame_condition_usages.end_date - (1/86400), engEffectiveRuleDate)))
4402: union
4403: select 1
4404: from ame_mandatory_attributes,
4405: ame_actions,
4406: ame_action_usages,
4407: ame_rules,
4408: ame_rule_usages

Line 4409: where ame_mandatory_attributes.attribute_id = ame_attributes.attribute_id

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 =
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

Line 4410: and ame_mandatory_attributes.action_type_id =

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 =
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

Line 4420: and engEffectiveRuleDate between ame_mandatory_attributes.start_date

4416: and ((engEffectiveRuleDate between ame_rules.start_date
4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
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

Line 4421: and nvl(ame_mandatory_attributes.end_date - (1/86400), engEffectiveRuleDate)

4417: and nvl(ame_rules.end_date - (1/86400), engEffectiveRuleDate)))
4418: and ((engEffectiveRuleDate between ame_rule_usages.start_date
4419: and nvl(ame_rule_usages.end_date - (1/86400), engEffectiveRuleDate)))
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)))