[Home] [Help]
1209: -- Also select for the item_id column in RTI so we can use
1210: -- this in looking up the values in MSN.
1211: CURSOR c_failure IS
1212: SELECT transaction_type, interface_transaction_id, item_id
1213: FROM rcv_transactions_interface rti
1214: WHERE rti.group_id = p_group_id
1215: AND rti.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER','RETURN TO RECEIVING','CORRECT');
1216:
1217: CURSOR c_newly_packed IS
1228: , rti.interface_transaction_id
1229: , rti.destination_type_code
1230: , rti.quantity rti_quantity
1231: , rti.parent_transaction_id
1232: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1233: WHERE rti.group_id = p_group_id
1234: AND rti.transaction_type = 'CORRECT'
1235: AND rt.transaction_id = rti.parent_transaction_id
1236: AND ((rt.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER') AND rti.quantity < 0) OR
1252: , rti.interface_transaction_id
1253: , rti.destination_type_code
1254: , rti.quantity rti_quantity
1255: , rti.parent_transaction_id
1256: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1257: WHERE msn.last_txn_source_name = rti.transaction_type
1258: AND msn.last_txn_source_id = rti.interface_transaction_id
1259: AND rti.group_id = p_group_id
1260: AND rti.transaction_type = 'CORRECT'
2237:
2238: BEGIN
2239:
2240: SELECT '1' INTO v_dummy FROM
2241: rcv_transactions_interface rti,wms_lpn_contents wlc
2242: WHERE rti.interface_transaction_id = wlc.source_header_id
2243: AND rti.processing_status_code = 'WSH_INTERFACED'
2244: AND rti.to_organization_id = wlc.organization_id
2245: AND wlc.parent_lpn_id = p_lpn_id
2541: ELSE
2542:
2543: l_position := '0050';
2544: open c_ref for SELECT NULL , NULL , NULL , rti.quantity, wlpnc.cost_group_id, RTI.secondary_quantity sec_qty--13399743
2545: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI
2546: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id
2547: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2548: AND WLPNC.INVENTORY_ITEM_ID = RTI.ITEM_ID
2549: AND nvl(WLPNC.SOURCE_NAME,'@@@') not in ('RETURN TO RECEIVING','RETURN TO VENDOR', 'RETURN TO CUSTOMER')
2828:
2829: l_position := '0010';
2830: x_return_status := FND_API.G_RET_STS_SUCCESS;
2831:
2832: SELECT transfer_lpn_id INTO l_lpn_id FROM rcv_transactions_interface
2833: WHERE interface_transaction_id = p_interface_txn_id;
2834:
2835: OPEN c_lpn_exist(l_lpn_id);
2836: FETCH c_lpn_exist INTO l_wdd_exists;
3081:
3082: BEGIN
3083:
3084: SELECT 1 INTO v_dummy
3085: FROM rcv_transactions_interface rti,wms_license_plate_numbers wlpn
3086: WHERE rti.interface_transaction_id = p_rcv_trx_interface_id
3087: AND rti.processing_status_code = 'WSH_INTERFACED'
3088: AND rti.transfer_lpn_id = wlpn.lpn_id
3089: AND wlpn.lpn_context = 5
3105: END IF;
3106:
3107: l_position := '0012';
3108:
3109: UPDATE rcv_transactions_interface SET transfer_lpn_id = l_lpn_id
3110: WHERE
3111: interface_transaction_id = p_rcv_trx_interface_id
3112: AND processing_status_code = 'WSH_INTERFACED' ;
3113:
3399: CURSOR c_get_lpnrti
3400: IS
3401: SELECT transfer_lpn_id,
3402: SUM(quantity) rti_qty
3403: FROM rcv_transactions_interface
3404: WHERE group_id = p_rtv_order
3405: AND PROCESSING_STATUS_CODE = 'WSH_INTERFACED'
3406: AND transfer_lpn_id IS NOT NULL
3407: GROUP BY transfer_lpn_id;
3603:
3604: ELSE
3605: l_position := '0050';
3606: open c_ref for SELECT NULL , NULL , NULL , rti.quantity
3607: FROM RCV_TRANSACTIONS_INTERFACE RTI
3608: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id;
3609:
3610: END IF;
3611: l_position := '0060';
3747: IF (l_debug = 1) THEN
3748: print_debug('l_rtiid =>' || l_rtiid);
3749: END IF;
3750:
3751: UPDATE RCV_TRANSACTIONS_INTERFACE
3752: SET GROUP_ID = p_group_id,
3753: PROCESSING_MODE_CODE = p_txn_proc_mode,
3754: MOBILE_TXN = 'Y'
3755: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;
3773: IF (l_debug = 1) THEN
3774: print_debug('l_rtiid =>' || l_rtiid);
3775: END IF;
3776:
3777: UPDATE RCV_TRANSACTIONS_INTERFACE
3778: SET GROUP_ID = p_group_id,
3779: PROCESSING_MODE_CODE = p_txn_proc_mode,
3780: MOBILE_TXN = 'Y'
3781: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;
3959: IF (l_debug = 1) THEN
3960: print_debug('l_rtiid =>' || l_rtiid);
3961: END IF;
3962:
3963: UPDATE RCV_TRANSACTIONS_INTERFACE
3964: SET GROUP_ID = p_group_id,
3965: PROCESSING_MODE_CODE = p_txn_proc_mode,
3966: MOBILE_TXN = 'Y'
3967: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;
3972: IF p_to_lpn_id <> 0 THEN
3973: IF (l_debug = 1) THEN
3974: print_debug('yes, p_to_lpn_id not zero ' || to_char(p_to_lpn_id));
3975: END IF;
3976: UPDATE RCV_TRANSACTIONS_INTERFACE
3977: SET TRANSFER_LPN_ID = p_to_lpn_id
3978: WHERE INTERFACE_TRANSACTION_ID = l_rtiid
3979: AND NVL(TRANSACTION_TYPE, '@@@') = 'RETURN TO RECEIVING';
3980: END IF;
4144: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4145: BEGIN
4146: OPEN x_lpn_lov FOR
4147: select distinct wlpnc.license_plate_number
4148: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti
4149: where rti.lpn_id = p_lpn_id
4150: and rti.item_id = p_item_id
4151: and nvl(rti.item_revision, '@@@') = nvl(p_revision, '@@@')
4152: and nvl(rti.transaction_type, '@@@') = 'RETURN TO RECEIVING'