[Home] [Help]
APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S
Line 184: SET transaction_id = mtl_system_items_interface_s.nextval,
180: */
181: stmt_num := 2;
182: LOOP
183: UPDATE bom_sub_comps_interface
184: SET transaction_id = mtl_system_items_interface_s.nextval,
185: transaction_type = upper(transaction_type)
186: WHERE transaction_id is null
187: AND process_flag = 1
188: AND (UPPER(interface_entity_type) = 'BILL'
Line 599: SELECT mtl_system_items_interface_s.nextval
595: stmt_num := 20;
596:
597: FOR c3rec in c3 LOOP
598: commit_cnt := commit_cnt + 1;
599: SELECT mtl_system_items_interface_s.nextval
600: INTO dummy_txn
601: FROM sys.dual;
602:
603: stmt_num := 21;