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 369: DELETE FROM BOM_BILL_OF_MATERIALS B

365:
366: -- Delete the bom header if bill was created by this revised item and
367: -- nothing else references this
368:
369: DELETE FROM BOM_BILL_OF_MATERIALS B
370: WHERE B.BILL_SEQUENCE_ID = bill_seq_id
371: AND B.PENDING_FROM_ECN = change_order
372: AND NOT EXISTS (SELECT NULL
373: FROM BOM_INVENTORY_COMPONENTS C

Line 379: FROM BOM_BILL_OF_MATERIALS B2

375: AND (C.REVISED_ITEM_SEQUENCE_ID IS NULL
376: OR C.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq))
377: AND ( (B.ALTERNATE_BOM_DESIGNATOR IS NULL
378: AND NOT EXISTS (SELECT NULL
379: FROM BOM_BILL_OF_MATERIALS B2
380: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
381: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
382: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
383: OR