DBA Data[Home] [Help]

APPS.AME_RULE_UTILITY_PKG dependencies on AME_MANDATORY_ATTRIBUTES

Line 178: ,ame_mandatory_attributes ama

174: select distinct atr.attribute_id, atr.name
175: from ame_attributes atr
176: ,ame_action_usages acu
177: ,ame_actions act
178: ,ame_mandatory_attributes ama
179: ,ame_rules rules
180: where ama.attribute_id = atr.attribute_id
181: and act.action_id = acu.action_id
182: and act.action_type_id = ama.action_type_id

Line 520: ,ame_mandatory_attributes ama

516: select distinct atr.attribute_id, atr.name
517: from ame_attributes atr
518: ,ame_action_usages acu
519: ,ame_actions act
520: ,ame_mandatory_attributes ama
521: ,ame_rules rules
522: where ama.attribute_id = atr.attribute_id
523: and act.action_id = acu.action_id
524: and act.action_type_id = ama.action_type_id

Line 1221: ,ame_mandatory_attributes man

1217: cursor getInvalidRequiredAttributes(applicationIdIn in integer
1218: ,actionIdIn in integer) is
1219: select distinct atr.attribute_id, atr.name
1220: from ame_attributes atr
1221: ,ame_mandatory_attributes man
1222: ,ame_actions act
1223: where act.action_id = actionIdIn
1224: and act.action_type_id = man.action_type_id
1225: and atr.attribute_id = man.attribute_id