DBA Data[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;