DBA Data[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 122: SELECT mtl_material_transactions_s.NEXTVAL

118: IF l_query_result <> 0 THEN
119:
120:
121: --Get value from sequence for next transaction_header_id
122: SELECT mtl_material_transactions_s.NEXTVAL
123: INTO l_next_transaction_header_id
124: FROM dual ;
125:
126: IF (l_debug = 1) THEN

Line 140: SELECT mtl_material_transactions_s.NEXTVAL

136:
137: -- Insert into mtl_material_transactions_temp
138:
139: --Get value from sequence for next transaction_temp_id
140: SELECT mtl_material_transactions_s.NEXTVAL
141: INTO l_next_transaction_temp_id
142: FROM dual ;
143:
144: IF (l_debug = 1) THEN

Line 658: SELECT mtl_material_transactions_s.NEXTVAL

654:
655: -- FOR LOT and SERIAL controlled items
656:
657: --Get value from sequence for next serial_transaction_temp_id
658: SELECT mtl_material_transactions_s.NEXTVAL
659: INTO l_next_ser_tran_temp_id
660: FROM dual;
661:
662: --Update MTLT line