DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1570: SELECT mtl_material_transactions_s.NEXTVAL

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

Line 1633: SELECT mtl_material_transactions_s.NEXTVAL

1629: IF (l_debug = 1) THEN
1630: mydebug(' source and destination sub location are not same ');
1631: END IF;
1632:
1633: SELECT mtl_material_transactions_s.NEXTVAL
1634: INTO new_txn_temp_id
1635: FROM DUAL;
1636:
1637: IF (l_debug = 1) THEN

Line 2063: SELECT mtl_material_transactions_s.NEXTVAL

2059: RAISE g_qty_not_avail;
2060: END IF;
2061:
2062: /**2706001 moved this out of below loop **/
2063: SELECT mtl_material_transactions_s.NEXTVAL
2064: INTO ser_transaction_temp_id
2065: FROM dual;
2066:
2067: /**2706001 was using cnt6 earlier **/