APPS.WMS_TASK_MGMT_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2265: SELECT mtl_material_transactions_s.NEXTVAL

2261: x_msg_data ,
2262: x_msg_count );
2263:
2264: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
2265: SELECT mtl_material_transactions_s.NEXTVAL
2266: INTO l_new_serial_txn_temp_id
2267: FROM dual;
2268: UPDATE mtl_transaction_lots_temp
2269: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,

Line 6758: SELECT mtl_material_transactions_s.NEXTVAL

6754: print_msg(l_procedure_name, ' SAVEPOINT wms_split_task established');
6755: END IF;
6756: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
6757: LOOP
6758: SELECT mtl_material_transactions_s.NEXTVAL
6759: INTO l_new_transaction_header_id
6760: FROM dual;
6761: SELECT mtl_material_transactions_s.NEXTVAL
6762: INTO l_new_transaction_temp_id

Line 6761: SELECT mtl_material_transactions_s.NEXTVAL

6757: LOOP
6758: SELECT mtl_material_transactions_s.NEXTVAL
6759: INTO l_new_transaction_header_id
6760: FROM dual;
6761: SELECT mtl_material_transactions_s.NEXTVAL
6762: INTO l_new_transaction_temp_id
6763: FROM dual;
6764: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6765: IF g_debug = 1 THEN