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 849: ENG_REVISED_ITEMS ERI

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

Line 872: ENG_REVISED_ITEMS ERI1

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

Line 3145: ENG_REVISED_ITEMS ERI

3141: nvl(A.DISABLE_DATE, p_bom_rev_date+1)
3142: AND A.EFFECTIVITY_DATE =
3143: (SELECT MAX(EFFECTIVITY_DATE)
3144: FROM BOM_INVENTORY_COMPONENTS BIC,
3145: ENG_REVISED_ITEMS ERI
3146: WHERE BIC.BILL_SEQUENCE_ID = A.BILL_SEQUENCE_ID
3147: AND BIC.COMPONENT_ITEM_ID = A.COMPONENT_ITEM_ID
3148: AND (decode(BIC.IMPLEMENTATION_DATE,
3149: NULL,

Line 3168: ENG_REVISED_ITEMS ERI1

3164: AND (nvl(ERI.STATUS_TYPE,6) IN (4,6,7))
3165: AND NOT EXISTS
3166: (SELECT 'X'
3167: FROM BOM_INVENTORY_COMPONENTS BICN,
3168: ENG_REVISED_ITEMS ERI1
3169: WHERE BICN.BILL_SEQUENCE_ID =
3170: A.BILL_SEQUENCE_ID
3171: AND BICN.OLD_COMPONENT_SEQUENCE_ID =
3172: A.COMPONENT_SEQUENCE_ID