DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1567: SELECT mtl_material_transactions_s.NEXTVAL

1563: IF (l_debug = 1) THEN
1564: mydebug('After calling get_temp_tables ');
1565: END IF;
1566:
1567: SELECT mtl_material_transactions_s.NEXTVAL
1568: INTO new_txn_header_id
1569: FROM DUAL;
1570:
1571: IF (l_debug = 1) THEN

Line 1624: SELECT mtl_material_transactions_s.NEXTVAL

1620: IF (l_debug = 1) THEN
1621: mydebug(' source and destination sub location are not same ');
1622: END IF;
1623:
1624: SELECT mtl_material_transactions_s.NEXTVAL
1625: INTO new_txn_temp_id
1626: FROM DUAL;
1627:
1628: IF (l_debug = 1) THEN

Line 2048: SELECT mtl_material_transactions_s.NEXTVAL

2044: RAISE g_qty_not_avail;
2045: END IF;
2046:
2047: /**2706001 moved this out of below loop **/
2048: SELECT mtl_material_transactions_s.NEXTVAL
2049: INTO ser_transaction_temp_id
2050: FROM dual;
2051:
2052: /**2706001 was using cnt6 earlier **/