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 346: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes

342: END LOOP;
343:
344: -- Delete the rows from bom_inventory_components
345:
346: DELETE FROM bom_components_b --BOM_INVENTORY_COMPONENTS IC -- R12: Modified for common bom changes
347: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
348:
349: -- Delete item revisions created by revised items on ECO
350: /* delete from MTL_ITEM_REVISIONS_TL

Line 2478: FROM bom_components_b bcb

2474: cp_change_notice eng_engineering_changes.change_notice%TYPE
2475: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2476: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2477: SELECT bcb.component_sequence_id
2478: FROM bom_components_b bcb
2479: WHERE bcb.CHANGE_NOTICE = cp_change_notice
2480: AND bcb.revised_item_sequence_id = cp_revised_item_seq_id
2481: AND bcb.bill_sequence_id = cp_bill_sequence_id
2482: AND (bcb.common_component_sequence_id IS NULL