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_RULE_UTILITY_PKG dependencies on AME_ATTRIBUTE_USAGES

Line 165: from ame_attribute_usages

161: and condu.rule_id = rules.rule_id
162: and rules.rule_id = ruleIdIn
163: and cond.condition_type <> ame_util.listModConditionType
164: and atr.attribute_id not in (select attribute_id
165: from ame_attribute_usages
166: where application_id = applicationIdIn
167: and sysdate between start_date
168: and nvl(end_date - (1/86400), sysdate))
169: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)

Line 186: from ame_attribute_usages

182: and act.action_type_id = ama.action_type_id
183: and acu.rule_id = rules.rule_id
184: and rules.rule_id = ruleIdIn
185: and ama.attribute_id not in (select attribute_id
186: from ame_attribute_usages
187: where application_id = applicationIdIn
188: and sysdate between start_date
189: and nvl(end_date - (1/86400), sysdate))
190: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)

Line 501: from ame_attribute_usages

497: and condu.rule_id = rules.rule_id
498: and rules.rule_id = ruleIdIn
499: and cond.condition_type <> ame_util.listModConditionType
500: and atr.attribute_id not in (select attribute_id
501: from ame_attribute_usages
502: where application_id = applicationIdIn
503: and sysdate between start_date
504: and nvl(end_date - (1/86400), sysdate))
505: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)

Line 528: from ame_attribute_usages

524: and act.action_type_id = ama.action_type_id
525: and acu.rule_id = rules.rule_id
526: and rules.rule_id = ruleIdIn
527: and ama.attribute_id not in (select attribute_id
528: from ame_attribute_usages
529: where application_id = applicationIdIn
530: and sysdate between start_date
531: and nvl(end_date - (1/86400), sysdate))
532: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)

Line 1126: from ame_attribute_usages atu

1122: and con.condition_type <> ame_util.listModConditionType
1123: and sysdate between atr.start_date and nvl(atr.end_date - (1/86400), sysdate)
1124: and sysdate between con.start_date and nvl(con.end_date - (1/86400), sysdate)
1125: and not exists (select attribute_id
1126: from ame_attribute_usages atu
1127: where atu.application_id = applicationIdIn
1128: and atu.attribute_id = atr.attribute_id
1129: and sysdate between atu.start_date
1130: and nvl(atu.end_date - (1/86400), sysdate));

Line 1227: from ame_attribute_usages atu

1223: where act.action_id = actionIdIn
1224: and act.action_type_id = man.action_type_id
1225: and atr.attribute_id = man.attribute_id
1226: and atr.attribute_id not in (select attribute_id
1227: from ame_attribute_usages atu
1228: where atu.application_id = applicationIdIn
1229: and atu.attribute_id = atr.attribute_id
1230: and sysdate between atu.start_date
1231: and nvl(atu.end_date - (1/86400), sysdate))

Line 1979: ,ame_attribute_usages atu

1975: cursor getConditions(p_application_id in integer
1976: ,p_condition_id in integer) is
1977: select count(*)
1978: from ame_conditions cnd
1979: ,ame_attribute_usages atu
1980: where cnd.condition_id = p_condition_id
1981: and cnd.condition_type <> ame_util.listModConditionType
1982: and atu.application_id = p_application_id
1983: and cnd.attribute_id = atu.attribute_id