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_ATTRIBUTE_PKG dependencies on AME_ITEM_CLASSES

Line 2804: ame_item_classes

2800: ame_attributes.name
2801: from
2802: ame_attributes,
2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and

Line 2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and

2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in

Line 2808: ame_item_classes.item_class_id = headerItemClassIdIn and

2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
2812: (select attribute_id from ame_mandatory_attributes

Line 2820: sysdate between ame_item_classes.start_date and

2816: sysdate between ame_attributes.start_date and
2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
2822: order by ame_attributes.name;
2823: headerItemClassId integer;
2824: tempIndex integer;

Line 2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)

2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
2822: order by ame_attributes.name;
2823: headerItemClassId integer;
2824: tempIndex integer;
2825: begin