APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 552: SELECT mtl_material_transactions_s.NEXTVAL

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

Line 562: SELECT mtl_material_transactions_s.NEXTVAL

558:
559: l_serial_control_code := inv_rcv_cache.get_sn_ctrl_code(p_organization_id,p_inventory_item_id);
560:
561: IF l_serial_control_code <> 1 THEN
562: SELECT mtl_material_transactions_s.NEXTVAL
563: INTO l_serial_transaction_temp_id
564: FROM sys.DUAL;
565: ELSE
566: l_serial_transaction_temp_id := NULL;

Line 1418: SELECT mtl_material_transactions_s.NEXTVAL

1414: x_return_status := fnd_api.g_ret_sts_success;
1415:
1416: --Generate transaction_interface_id if necessary
1417: IF (p_transaction_interface_id IS NULL) THEN
1418: SELECT mtl_material_transactions_s.NEXTVAL
1419: INTO l_transaction_interface_id
1420: FROM sys.dual;
1421: ELSE
1422: l_transaction_interface_id := p_transaction_interface_id;

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

4137: ,operation_plan_id
4138: ,move_order_header_id
4139: ,serial_allocated_flag )
4140: VALUES
4141: ( mtl_material_transactions_s.NEXTVAL --use different header
4142: ,mtl_material_transactions_s.NEXTVAL
4143: ,l_new_mmtt_rec.SOURCE_CODE
4144: ,l_new_mmtt_rec.SOURCE_LINE_ID
4145: ,l_new_mmtt_rec.TRANSACTION_MODE

Line 4142: ,mtl_material_transactions_s.NEXTVAL

4138: ,move_order_header_id
4139: ,serial_allocated_flag )
4140: VALUES
4141: ( mtl_material_transactions_s.NEXTVAL --use different header
4142: ,mtl_material_transactions_s.NEXTVAL
4143: ,l_new_mmtt_rec.SOURCE_CODE
4144: ,l_new_mmtt_rec.SOURCE_LINE_ID
4145: ,l_new_mmtt_rec.TRANSACTION_MODE
4146: ,l_new_mmtt_rec.LOCK_FLAG

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

6162: ,operation_plan_id
6163: ,move_order_header_id
6164: ,serial_allocated_flag )
6165: VALUES
6166: ( mtl_material_transactions_s.NEXTVAL --use different header
6167: ,mtl_material_transactions_s.NEXTVAL
6168: ,l_mmtt_rec.SOURCE_CODE
6169: ,l_mmtt_rec.SOURCE_LINE_ID
6170: ,l_mmtt_rec.TRANSACTION_MODE

Line 6167: ,mtl_material_transactions_s.NEXTVAL

6163: ,move_order_header_id
6164: ,serial_allocated_flag )
6165: VALUES
6166: ( mtl_material_transactions_s.NEXTVAL --use different header
6167: ,mtl_material_transactions_s.NEXTVAL
6168: ,l_mmtt_rec.SOURCE_CODE
6169: ,l_mmtt_rec.SOURCE_LINE_ID
6170: ,l_mmtt_rec.TRANSACTION_MODE
6171: ,l_mmtt_rec.LOCK_FLAG