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 5053: ame_item_classes.item_class_id,

5049: end fetchInsertedApprovers;
5050: procedure fetchItemClassData as
5051: cursor itemClassUsageCursor(applicationIdIn in integer) is
5052: select
5053: ame_item_classes.item_class_id,
5054: ame_item_classes.name,
5055: ame_item_class_usages.item_id_query,
5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,

Line 5054: ame_item_classes.name,

5050: procedure fetchItemClassData as
5051: cursor itemClassUsageCursor(applicationIdIn in integer) is
5052: select
5053: ame_item_classes.item_class_id,
5054: ame_item_classes.name,
5055: ame_item_class_usages.item_id_query,
5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode

Line 5060: ame_item_classes,

5056: ame_item_class_usages.item_class_order_number,
5057: ame_item_class_usages.item_class_par_mode,
5058: ame_item_class_usages.item_class_sublist_mode
5059: from
5060: ame_item_classes,
5061: ame_item_class_usages
5062: where
5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and

Line 5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

5059: from
5060: ame_item_classes,
5061: ame_item_class_usages
5062: where
5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and
5065: engEffectiveRuleDate between
5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 5066: ame_item_classes.start_date and

5062: where
5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and
5065: engEffectiveRuleDate between
5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5068: engEffectiveRuleDate between
5069: ame_item_class_usages.start_date and
5070: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

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

5063: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
5064: ame_item_class_usages.application_id = applicationIdIn and
5065: engEffectiveRuleDate between
5066: ame_item_classes.start_date and
5067: nvl(ame_item_classes.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
5068: engEffectiveRuleDate between
5069: ame_item_class_usages.start_date and
5070: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
5071: /*