APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 556: SELECT mtl_material_transactions_s.NEXTVAL

552: END IF; --END IF p_transaction_interface_id IS NOT NULL
553:
554: --Generate transaction_interface_id if the parameter is NULL
555: IF (p_transaction_interface_id IS NULL) THEN
556: SELECT mtl_material_transactions_s.NEXTVAL
557: INTO l_transaction_interface_id
558: FROM sys.dual;
559: ELSE
560: l_transaction_interface_id := p_transaction_interface_id;

Line 566: SELECT mtl_material_transactions_s.NEXTVAL

562:
563: l_serial_control_code := inv_rcv_cache.get_sn_ctrl_code(p_organization_id,p_inventory_item_id);
564:
565: IF l_serial_control_code not in (1,6) THEN -- Bug 9008016
566: SELECT mtl_material_transactions_s.NEXTVAL
567: INTO l_serial_transaction_temp_id
568: FROM sys.DUAL;
569: ELSE
570: l_serial_transaction_temp_id := NULL;

Line 1434: SELECT mtl_material_transactions_s.NEXTVAL

1430: x_return_status := fnd_api.g_ret_sts_success;
1431:
1432: --Generate transaction_interface_id if necessary
1433: IF (p_transaction_interface_id IS NULL) THEN
1434: SELECT mtl_material_transactions_s.NEXTVAL
1435: INTO l_transaction_interface_id
1436: FROM sys.dual;
1437: ELSE
1438: l_transaction_interface_id := p_transaction_interface_id;

Line 4210: ( mtl_material_transactions_s.NEXTVAL --use different header

4206: ,operation_plan_id
4207: ,move_order_header_id
4208: ,serial_allocated_flag )
4209: VALUES
4210: ( mtl_material_transactions_s.NEXTVAL --use different header
4211: ,mtl_material_transactions_s.NEXTVAL
4212: ,l_new_mmtt_rec.SOURCE_CODE
4213: ,l_new_mmtt_rec.SOURCE_LINE_ID
4214: ,l_new_mmtt_rec.TRANSACTION_MODE

Line 4211: ,mtl_material_transactions_s.NEXTVAL

4207: ,move_order_header_id
4208: ,serial_allocated_flag )
4209: VALUES
4210: ( mtl_material_transactions_s.NEXTVAL --use different header
4211: ,mtl_material_transactions_s.NEXTVAL
4212: ,l_new_mmtt_rec.SOURCE_CODE
4213: ,l_new_mmtt_rec.SOURCE_LINE_ID
4214: ,l_new_mmtt_rec.TRANSACTION_MODE
4215: ,l_new_mmtt_rec.LOCK_FLAG

Line 6235: ( mtl_material_transactions_s.NEXTVAL --use different header

6231: ,operation_plan_id
6232: ,move_order_header_id
6233: ,serial_allocated_flag )
6234: VALUES
6235: ( mtl_material_transactions_s.NEXTVAL --use different header
6236: ,mtl_material_transactions_s.NEXTVAL
6237: ,l_mmtt_rec.SOURCE_CODE
6238: ,l_mmtt_rec.SOURCE_LINE_ID
6239: ,l_mmtt_rec.TRANSACTION_MODE

Line 6236: ,mtl_material_transactions_s.NEXTVAL

6232: ,move_order_header_id
6233: ,serial_allocated_flag )
6234: VALUES
6235: ( mtl_material_transactions_s.NEXTVAL --use different header
6236: ,mtl_material_transactions_s.NEXTVAL
6237: ,l_mmtt_rec.SOURCE_CODE
6238: ,l_mmtt_rec.SOURCE_LINE_ID
6239: ,l_mmtt_rec.TRANSACTION_MODE
6240: ,l_mmtt_rec.LOCK_FLAG