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_CHANGE_IMPORT_UTIL dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 2924: FROM BOM_BILL_OF_MTLS_INTERFACE bom,

2920: Write_Debug('Populate CO Id to item interface table by using CO Id in bom insterface ');
2921: begin
2922: SELECT NVL(bom.change_id, -100), bom.assembly_item_id
2923: into l_change_id, l_inventory_item_id
2924: FROM BOM_BILL_OF_MTLS_INTERFACE bom,
2925: MTL_SYSTEM_ITEMS_INTERFACE item
2926: WHERE item.set_process_id = p_batch_id
2927: and item.organization_id = bom.organization_id
2928: and item.inventory_item_id =

Line 2931: FROM BOM_BILL_OF_MTLS_INTERFACE bom_itfc

2927: and item.organization_id = bom.organization_id
2928: and item.inventory_item_id =
2929: (select assembly_item_id
2930: from (select assembly_item_id
2931: FROM BOM_BILL_OF_MTLS_INTERFACE bom_itfc
2932: WHERE bom_itfc.batch_id = p_batch_id
2933: order by creation_date desc)
2934: where rownum = 1)
2935: and item.inventory_item_id = bom.assembly_item_id

Line 4558: INSERT INTO bom_bill_of_mtls_interface

4554:
4555: Write_Debug('l_bill_sequence_id: ' || to_char(l_bill_sequence_id));
4556:
4557: Write_Debug('Inserting data into interface tables:');
4558: INSERT INTO bom_bill_of_mtls_interface
4559: (ASSEMBLY_ITEM_ID,
4560: ORGANIZATION_ID,
4561: ALTERNATE_BOM_DESIGNATOR,
4562: BILL_SEQUENCE_ID,