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.ENG_REVISED_ITEM_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 386: DELETE FROM BOM_BILL_OF_MATERIALS B

382:
383: -- Delete the bom header if bill was created by this revised item and
384: -- nothing else references this
385:
386: DELETE FROM BOM_BILL_OF_MATERIALS B
387: WHERE B.BILL_SEQUENCE_ID = bill_seq_id
388: AND B.PENDING_FROM_ECN = change_order
389: AND NOT EXISTS (SELECT NULL
390: FROM BOM_INVENTORY_COMPONENTS C

Line 396: FROM BOM_BILL_OF_MATERIALS B2

392: AND (C.REVISED_ITEM_SEQUENCE_ID IS NULL
393: OR C.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq))
394: AND ( (B.ALTERNATE_BOM_DESIGNATOR IS NULL
395: AND NOT EXISTS (SELECT NULL
396: FROM BOM_BILL_OF_MATERIALS B2
397: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
398: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
399: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
400: OR