DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2630: SELECT mtl_material_transactions_s.NEXTVAL

2626: END IF;
2627:
2628: SAVEPOINT split_mmtt_sp;
2629:
2630: SELECT mtl_material_transactions_s.NEXTVAL
2631: INTO l_new_temp_id
2632: FROM dual;
2633:
2634: IF l_debug = 1 THEN

Line 4960: SELECT mtl_material_transactions_s.NEXTVAL

4956: );
4957: END IF;
4958: END IF;
4959:
4960: SELECT mtl_material_transactions_s.NEXTVAL
4961: INTO l_serial_temp_id
4962: FROM dual;
4963:
4964: IF l_debug = 1 THEN

Line 7105: SELECT mtl_material_transactions_s.NEXTVAL

7101: END;
7102:
7103: IF l_srl_temp_id IS NULL
7104: THEN
7105: SELECT mtl_material_transactions_s.NEXTVAL
7106: INTO l_srl_temp_id
7107: FROM dual;
7108:
7109: IF l_debug = 1 THEN

Line 8366: SELECT mtl_material_transactions_s.NEXTVAL

8362: END IF;
8363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8364: END;
8365:
8366: SELECT mtl_material_transactions_s.NEXTVAL
8367: INTO l_pack_temp_id
8368: FROM DUAL;
8369:
8370: IF l_debug = 1 THEN

Line 9694: SELECT mtl_material_transactions_s.NEXTVAL

9690:
9691: --
9692: -- Generate a new transaction header ID
9693: --
9694: SELECT mtl_material_transactions_s.NEXTVAL
9695: INTO l_txn_header_id
9696: FROM dual;
9697:
9698: IF l_debug = 1 THEN

Line 10186: SELECT mtl_material_transactions_s.NEXTVAL

10182: , l_api_name
10183: );
10184: END IF;
10185:
10186: SELECT mtl_material_transactions_s.NEXTVAL
10187: INTO l_txn_header_id
10188: FROM dual;
10189:
10190: IF l_debug = 1 THEN