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.BOM_REFERENCE_DESIGNATOR_API dependencies on MTL_SYSTEM_ITEMS

Line 162: SET transaction_id = mtl_system_items_interface_s.nextval,

158: */
159: stmt_num := 2;
160: LOOP
161: UPDATE bom_ref_desgs_interface
162: SET transaction_id = mtl_system_items_interface_s.nextval,
163: transaction_type = upper(transaction_type)
164: WHERE transaction_id is null
165: AND (UPPER(interface_entity_type) = 'BILL'
166: OR interface_entity_type is null)

Line 447: SELECT mtl_system_items_interface_s.nextval

443: /******************* Removed as a fix for bug 916428 *************************
444: stmt_num := 16;
445: FOR c3rec in c3 LOOP
446: commit_cnt := commit_cnt + 1;
447: SELECT mtl_system_items_interface_s.nextval
448: INTO dummy_txn
449: FROM sys.dual;
450:
451: stmt_num := 17;

Line 1088: mtl_system_items mtl

1084: comp_id_dummy, comp_type, dummy,
1085: X_component_quantity, X_quantity_related
1086: FROM bom_inventory_components bic,
1087: bom_bill_of_materials bbom,
1088: mtl_system_items mtl
1089: WHERE bic.component_sequence_id = c1rec.CSI
1090: AND bic.implementation_date is not null
1091: AND bbom.bill_sequence_id = bic.bill_sequence_id
1092: AND mtl.inventory_item_id = bbom.assembly_item_id