APPS.WMS_PICK_DROP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2487: SELECT mtl_material_transactions_s.NEXTVAL

2483: END IF;
2484:
2485: SAVEPOINT split_mmtt_sp;
2486:
2487: SELECT mtl_material_transactions_s.NEXTVAL
2488: INTO l_new_temp_id
2489: FROM dual;
2490:
2491: IF l_debug = 1 THEN

Line 4682: SELECT mtl_material_transactions_s.NEXTVAL

4678: );
4679: END IF;
4680: END IF;
4681:
4682: SELECT mtl_material_transactions_s.NEXTVAL
4683: INTO l_serial_temp_id
4684: FROM dual;
4685:
4686: IF l_debug = 1 THEN

Line 6827: SELECT mtl_material_transactions_s.NEXTVAL

6823: END;
6824:
6825: IF l_srl_temp_id IS NULL
6826: THEN
6827: SELECT mtl_material_transactions_s.NEXTVAL
6828: INTO l_srl_temp_id
6829: FROM dual;
6830:
6831: IF l_debug = 1 THEN

Line 8072: SELECT mtl_material_transactions_s.NEXTVAL

8068: END IF;
8069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8070: END;
8071:
8072: SELECT mtl_material_transactions_s.NEXTVAL
8073: INTO l_pack_temp_id
8074: FROM DUAL;
8075:
8076: IF l_debug = 1 THEN

Line 9375: SELECT mtl_material_transactions_s.NEXTVAL

9371:
9372: --
9373: -- Generate a new transaction header ID
9374: --
9375: SELECT mtl_material_transactions_s.NEXTVAL
9376: INTO l_txn_header_id
9377: FROM dual;
9378:
9379: IF l_debug = 1 THEN

Line 9863: SELECT mtl_material_transactions_s.NEXTVAL

9859: , l_api_name
9860: );
9861: END IF;
9862:
9863: SELECT mtl_material_transactions_s.NEXTVAL
9864: INTO l_txn_header_id
9865: FROM dual;
9866:
9867: IF l_debug = 1 THEN