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_TRANS_TYPE_API dependencies on AME_MANDATORY_ATTRIBUTES

Line 30: ame_mandatory_attributes

26: cursor getMandatoryAttributesCur is
27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)

Line 31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id

27: select ame_attributes.attribute_id,
28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and

Line 32: and ame_mandatory_attributes.action_type_id = -1

28: ame_attributes.attribute_type
29: from ame_attributes,
30: ame_mandatory_attributes
31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);

Line 35: and sysdate between ame_mandatory_attributes.start_date and

31: where ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id
32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is
38: select item_class_id
39: from ame_item_classes

Line 36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);

32: and ame_mandatory_attributes.action_type_id = -1
33: and sysdate between ame_attributes.start_date and
34: nvl(ame_attributes.end_date - (1/86400), sysdate)
35: and sysdate between ame_mandatory_attributes.start_date and
36: nvl(ame_mandatory_attributes.end_date - (1/86400), sysdate);
37: cursor getHeaderItemId is
38: select item_class_id
39: from ame_item_classes
40: where name = ame_util.headerItemClassName