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_ITEM_CLASSES

Line 5093: ame_item_classes.item_class_id,

5089: end fetchInsertedApprovers;
5090: procedure fetchItemClassData as
5091: cursor itemClassUsageCursor(applicationIdIn in integer) is
5092: select
5093: ame_item_classes.item_class_id,
5094: ame_item_classes.name,
5095: ame_item_class_usages.item_id_query,
5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,

Line 5094: ame_item_classes.name,

5090: procedure fetchItemClassData as
5091: cursor itemClassUsageCursor(applicationIdIn in integer) is
5092: select
5093: ame_item_classes.item_class_id,
5094: ame_item_classes.name,
5095: ame_item_class_usages.item_id_query,
5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode

Line 5100: ame_item_classes,

5096: ame_item_class_usages.item_class_order_number,
5097: ame_item_class_usages.item_class_par_mode,
5098: ame_item_class_usages.item_class_sublist_mode
5099: from
5100: ame_item_classes,
5101: ame_item_class_usages
5102: where
5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and

Line 5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

5099: from
5100: ame_item_classes,
5101: ame_item_class_usages
5102: where
5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and
5105: engEffectiveRuleDate between
5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 5106: ame_item_classes.start_date and

5102: where
5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and
5105: engEffectiveRuleDate between
5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5108: engEffectiveRuleDate between
5109: ame_item_class_usages.start_date and
5110: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

Line 5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

5103: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5104: ame_item_class_usages.application_id = applicationIdIn and
5105: engEffectiveRuleDate between
5106: ame_item_classes.start_date and
5107: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5108: engEffectiveRuleDate between
5109: ame_item_class_usages.start_date and
5110: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
5111: /*