[Home] [Help]
1190: -- Also select for the item_id column in RTI so we can use
1191: -- this in looking up the values in MSN.
1192: CURSOR c_failure IS
1193: SELECT transaction_type, interface_transaction_id, item_id
1194: FROM rcv_transactions_interface rti
1195: WHERE rti.group_id = p_group_id
1196: AND rti.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER','RETURN TO RECEIVING','CORRECT');
1197:
1198: CURSOR c_newly_packed IS
1209: , rti.interface_transaction_id
1210: , rti.destination_type_code
1211: , rti.quantity rti_quantity
1212: , rti.parent_transaction_id
1213: FROM wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1214: WHERE rti.group_id = p_group_id
1215: AND rti.transaction_type = 'CORRECT'
1216: AND rt.transaction_id = rti.parent_transaction_id
1217: AND ((rt.transaction_type in ('RETURN TO VENDOR','RETURN TO CUSTOMER') AND rti.quantity < 0) OR
1233: , rti.interface_transaction_id
1234: , rti.destination_type_code
1235: , rti.quantity rti_quantity
1236: , rti.parent_transaction_id
1237: FROM mtl_serial_numbers msn, wms_lpn_contents wlpnc, rcv_transactions_interface rti, rcv_transactions rt
1238: WHERE msn.last_txn_source_name = rti.transaction_type
1239: AND msn.last_txn_source_id = rti.interface_transaction_id
1240: AND rti.group_id = p_group_id
1241: AND rti.transaction_type = 'CORRECT'
2444: ELSE
2445:
2446: l_position := '0050';
2447: open c_ref for SELECT NULL , NULL , NULL , rti.quantity, wlpnc.cost_group_id
2448: FROM WMS_LPN_CONTENTS WLPNC, RCV_TRANSACTIONS_INTERFACE RTI
2449: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id
2450: AND WLPNC.PARENT_LPN_ID = p_lpn_id
2451: AND WLPNC.INVENTORY_ITEM_ID = RTI.ITEM_ID
2452: AND nvl(WLPNC.SOURCE_NAME,'@@@') not in ('RETURN TO RECEIVING','RETURN TO VENDOR', 'RETURN TO CUSTOMER')
2691:
2692: ELSE
2693: l_position := '0050';
2694: open c_ref for SELECT NULL , NULL , NULL , rti.quantity
2695: FROM RCV_TRANSACTIONS_INTERFACE RTI
2696: WHERE RTI.INTERFACE_TRANSACTION_ID = p_rcv_trx_interface_id;
2697:
2698: END IF;
2699: l_position := '0060';
2835: IF (l_debug = 1) THEN
2836: print_debug('l_rtiid =>' || l_rtiid);
2837: END IF;
2838:
2839: UPDATE RCV_TRANSACTIONS_INTERFACE
2840: SET GROUP_ID = p_group_id,
2841: PROCESSING_MODE_CODE = p_txn_proc_mode,
2842: MOBILE_TXN = 'Y'
2843: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;
2861: IF (l_debug = 1) THEN
2862: print_debug('l_rtiid =>' || l_rtiid);
2863: END IF;
2864:
2865: UPDATE RCV_TRANSACTIONS_INTERFACE
2866: SET GROUP_ID = p_group_id,
2867: PROCESSING_MODE_CODE = p_txn_proc_mode,
2868: MOBILE_TXN = 'Y'
2869: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;
3047: IF (l_debug = 1) THEN
3048: print_debug('l_rtiid =>' || l_rtiid);
3049: END IF;
3050:
3051: UPDATE RCV_TRANSACTIONS_INTERFACE
3052: SET GROUP_ID = p_group_id,
3053: PROCESSING_MODE_CODE = p_txn_proc_mode,
3054: MOBILE_TXN = 'Y'
3055: WHERE INTERFACE_TRANSACTION_ID = l_rtiid;
3060: IF p_to_lpn_id <> 0 THEN
3061: IF (l_debug = 1) THEN
3062: print_debug('yes, p_to_lpn_id not zero ' || to_char(p_to_lpn_id));
3063: END IF;
3064: UPDATE RCV_TRANSACTIONS_INTERFACE
3065: SET TRANSFER_LPN_ID = p_to_lpn_id
3066: WHERE INTERFACE_TRANSACTION_ID = l_rtiid
3067: AND NVL(TRANSACTION_TYPE, '@@@') = 'RETURN TO RECEIVING';
3068: END IF;
3232: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3233: BEGIN
3234: OPEN x_lpn_lov FOR
3235: select distinct wlpnc.license_plate_number
3236: from wms_license_plate_numbers wlpnc, rcv_transactions_interface rti
3237: where rti.lpn_id = p_lpn_id
3238: and rti.item_id = p_item_id
3239: and nvl(rti.item_revision, '@@@') = nvl(p_revision, '@@@')
3240: and nvl(rti.transaction_type, '@@@') = 'RETURN TO RECEIVING'