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_COMPONENTS_B

Line 363: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes

359: END LOOP;
360:
361: -- Delete the rows from bom_inventory_components
362:
363: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
364: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
365:
366: -- Delete item revisions created by revised items on ECO
367: /* delete from MTL_ITEM_REVISIONS_TL

Line 2502: FROM bom_components_b bcb

2498: cp_change_notice eng_engineering_changes.change_notice%TYPE
2499: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2500: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2501: SELECT bcb.component_sequence_id
2502: FROM bom_components_b bcb
2503: WHERE bcb.CHANGE_NOTICE = cp_change_notice
2504: AND bcb.revised_item_sequence_id = cp_revised_item_seq_id
2505: AND bcb.bill_sequence_id = cp_bill_sequence_id
2506: AND (bcb.common_component_sequence_id IS NULL