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

Line 2861: from ame_item_classes, ame_item_class_usages

2857: ruleType := ruleTypeIn;
2858: end if;
2859: select count(*)
2860: into lineItemClassCount
2861: from ame_item_classes, ame_item_class_usages
2862: where
2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and

Line 2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

2859: select count(*)
2860: into lineItemClassCount
2861: from ame_item_classes, ame_item_class_usages
2862: where
2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2866: sysdate between
2867: ame_item_classes.start_date and

Line 2865: ame_item_classes.name = ame_util.lineItemItemClassName and

2861: from ame_item_classes, ame_item_class_usages
2862: where
2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2866: sysdate between
2867: ame_item_classes.start_date and
2868: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2869: sysdate

Line 2867: ame_item_classes.start_date and

2863: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2866: sysdate between
2867: ame_item_classes.start_date and
2868: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2869: sysdate
2870: between ame_item_class_usages.start_date and
2871: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

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

2864: ame_item_class_usages.application_id = applicationIdIn and
2865: ame_item_classes.name = ame_util.lineItemItemClassName and
2866: sysdate between
2867: ame_item_classes.start_date and
2868: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2869: sysdate
2870: between ame_item_class_usages.start_date and
2871: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
2872: allowProductions := ame_util.getConfigVar(variableNameIn => ame_util.productionConfigVar,

Line 2982: from ame_item_classes, ame_item_class_usages

2978: lineItemClassCount integer;
2979: begin
2980: select count(*)
2981: into lineItemClassCount
2982: from ame_item_classes, ame_item_class_usages
2983: where
2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and

Line 2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and

2980: select count(*)
2981: into lineItemClassCount
2982: from ame_item_classes, ame_item_class_usages
2983: where
2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2987: sysdate between
2988: ame_item_classes.start_date and

Line 2986: ame_item_classes.name = ame_util.lineItemItemClassName and

2982: from ame_item_classes, ame_item_class_usages
2983: where
2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2987: sysdate between
2988: ame_item_classes.start_date and
2989: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2990: sysdate

Line 2988: ame_item_classes.start_date and

2984: ame_item_classes.item_class_id = ame_item_class_usages.item_class_id and
2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2987: sysdate between
2988: ame_item_classes.start_date and
2989: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2990: sysdate
2991: between ame_item_class_usages.start_date and
2992: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);

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

2985: ame_item_class_usages.application_id = applicationIdIn and
2986: ame_item_classes.name = ame_util.lineItemItemClassName and
2987: sysdate between
2988: ame_item_classes.start_date and
2989: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate) and
2990: sysdate
2991: between ame_item_class_usages.start_date and
2992: nvl(ame_item_class_usages.end_date - ame_util.oneSecond, sysdate);
2993: allowProductions := ame_util.getConfigVar(variableNameIn => ame_util.productionConfigVar,