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.WSM_JOBCOPIES_PVT dependencies on ENG_REVISED_ITEMS

Line 633: ENG_REVISED_ITEMS ERI

629: )
630: AND p_bom_rev_date between a.effectivity_date and nvl(a.disable_date, p_bom_rev_date+1)
631: AND A.EFFECTIVITY_DATE = (SELECT MAX(EFFECTIVITY_DATE)
632: FROM BOM_INVENTORY_COMPONENTS BIC,
633: ENG_REVISED_ITEMS ERI
634: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
635: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
636: AND (decode(BIC.IMPLEMENTATION_DATE,
637: NULL,

Line 656: ENG_REVISED_ITEMS ERI1

652: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
653: AND NOT EXISTS
654: (SELECT 'X'
655: FROM BOM_INVENTORY_COMPONENTS BICN,
656: ENG_REVISED_ITEMS ERI1
657: WHERE BICN.BILL_SEQUENCE_ID =
658: A.BILL_SEQUENCE_ID
659: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
660: A.COMPONENT_SEQUENCE_ID

Line 848: ENG_REVISED_ITEMS ERI

844: )
845: AND p_bom_rev_date BETWEEN A.EFFECTIVITY_DATE and nvl(A.DISABLE_DATE, p_bom_rev_date+1)
846: AND A.EFFECTIVITY_DATE = (SELECT MAX(EFFECTIVITY_DATE)
847: FROM BOM_INVENTORY_COMPONENTS BIC,
848: ENG_REVISED_ITEMS ERI
849: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
850: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
851: AND (decode(BIC.IMPLEMENTATION_DATE,
852: NULL,

Line 871: ENG_REVISED_ITEMS ERI1

867: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
868: AND NOT EXISTS
869: (SELECT 'X'
870: FROM BOM_INVENTORY_COMPONENTS BICN,
871: ENG_REVISED_ITEMS ERI1
872: WHERE BICN.BILL_SEQUENCE_ID =
873: A.BILL_SEQUENCE_ID
874: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
875: A.COMPONENT_SEQUENCE_ID

Line 2914: ENG_REVISED_ITEMS ERI

2910: nvl(A.DISABLE_DATE, p_bom_rev_date+1)
2911: AND A.EFFECTIVITY_DATE =
2912: (SELECT MAX(EFFECTIVITY_DATE)
2913: FROM BOM_INVENTORY_COMPONENTS BIC,
2914: ENG_REVISED_ITEMS ERI
2915: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
2916: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
2917: AND (decode(BIC.IMPLEMENTATION_DATE,
2918: NULL,

Line 2937: ENG_REVISED_ITEMS ERI1

2933: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
2934: AND NOT EXISTS
2935: (SELECT 'X'
2936: FROM BOM_INVENTORY_COMPONENTS BICN,
2937: ENG_REVISED_ITEMS ERI1
2938: WHERE BICN.BILL_SEQUENCE_ID =
2939: A.BILL_SEQUENCE_ID
2940: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
2941: A.COMPONENT_SEQUENCE_ID