[Home] [Help]
2825: --If no MOL found, then get project and task from RTI
2826: BEGIN
2827: SELECT project_id,task_id
2828: INTO l_project_id,l_task_id
2829: FROM rcv_transactions_interface
2830: WHERE transfer_lpn_id = p_lpn_id
2831: AND transaction_type = 'RECEIVE'
2832: AND transaction_status_code = 'PENDING'
2833: AND processing_status_code <> 'ERROR'
4190: /* Two new parameter x_lpn_context and x_default_source have been added
4191: * to return the lpn_context and a flag that indicates how the
4192: * subinventory and locator have been defaulted. Possible values are:
4193: * LPN -> Sub and locator are derived from WMS_LICENSE_PLATE_NUMBERS
4194: * RTI -> Sub and locator are derived from RCV_TRANSACTIONS_INTERFACE
4195: * DOC -> Sub and locator are derived from document (POD/RSL/REQ)
4196: * ITD -> Sub and locator are derived from item transaction defaults
4197: * NONE -> There is no default sub and locator being returned
4198: * This validation is applicable only if INV and PO patch levels are J or
4295: IF (l_debug = 1) THEN
4296: print_debug('get_sub_code: WMS and PO are J or higher: should also check for sub/loc from RTI', 4);
4297: END IF;
4298:
4299: --Get the subinventory, locator_id and routing from rcv_transactions_interface
4300: --If there exists one and it is not direct then error out with the
4301: --"Invalid LPN context" error since we cannot commingle routings in the same LPN
4302: BEGIN
4303: SELECT NVL(subinventory, '@@@')
4305: , auto_transact_code
4306: INTO x_sub_code
4307: , l_locator_id
4308: , l_auto_transact_code
4309: FROM rcv_transactions_interface
4310: WHERE transfer_lpn_id = p_lpn_id
4311: AND transaction_type = 'RECEIVE'
4312: AND transaction_status_code = 'PENDING'
4313: AND processing_status_code <> 'ERROR'
6272: WHERE item_id = p_item_id
6273: AND to_organization_id = p_organization_id
6274: AND EXISTS(
6275: SELECT 1
6276: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
6277: WHERE prl.requisition_header_id = p_requiition_header_id
6278: AND rsl.requisition_line_id = prl.requisition_line_id
6279: AND prl.item_id = p_item_id
6280: AND prl.source_type_code = 'INVENTORY'
6287: AND rt.organization_id = p_organization_id
6288: AND(
6289: EXISTS(
6290: SELECT 1
6291: FROM rcv_transactions rt1
6292: WHERE rt1.transaction_id = rt.transaction_id
6293: AND rt1.inspection_status_code <> 'NOT INSPECTED'
6294: AND rt1.routing_header_id = 2)
6295: OR rt.routing_header_id <> 2
6435: WHERE item_id = p_item_id
6436: AND to_organization_id = p_organization_id
6437: AND EXISTS(
6438: SELECT 1
6439: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
6440: WHERE prl.requisition_header_id = p_requiition_header_id
6441: AND rsl.requisition_line_id = prl.requisition_line_id
6442: AND prl.item_id = p_item_id
6443: AND prl.source_type_code = 'INVENTORY'
6449: AND rs.to_organization_id = p_organization_id
6450: AND rt.organization_id = p_organization_id
6451: AND(EXISTS(
6452: SELECT 1
6453: FROM rcv_transactions rt1
6454: WHERE rt1.transaction_id = rt.transaction_id
6455: AND rt1.inspection_status_code = 'NOT INSPECTED'
6456: AND rt1.routing_header_id = 2)
6457: ));
7485: -- Retrieval of x_lpn_flag is changed
7486: --
7487: SELECT 'Y'
7488: INTO x_lpn_flag
7489: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc, rcv_transactions_interface rti
7490: WHERE lpn.lpn_id = wlc.parent_lpn_id
7491: AND lpn.lpn_id = rti.lpn_id
7492: AND rti.transaction_status_code = 'PENDING'
7493: AND lpn.lpn_id IN(SELECT lpn_id
7577:
7578: IF l_sub_code IS NULL THEN
7579: BEGIN
7580: l_progress := '30';
7581: --Get the subinventory, locator_id and routing from rcv_transactions_interface
7582: --If there exists one and it is not direct then error out with the
7583: --"Invalid LPN context" error since we cannot commingle routings in the same LPN
7584: SELECT subinventory
7585: , locator_id
7588: INTO l_sub_code
7589: , l_locator_id
7590: , l_location_id
7591: , l_auto_transact_code
7592: FROM rcv_transactions_interface
7593: WHERE transfer_lpn_id = p_lpn_id
7594: AND transaction_type = 'RECEIVE'
7595: AND transaction_status_code = 'PENDING'
7596: AND processing_status_code <> 'ERROR'
7761: -- Check if there is any existing RTI Record for the given LPN or their childs.
7762:
7763: BEGIN
7764: SELECT 'N' INTO x_lpn_flag
7765: FROM rcv_transactions_interface
7766: WHERE lpn_id IN ( SELECT lpn_id FROM wms_license_plate_numbers
7767: START WITH lpn_id = p_lpn_id
7768: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7769: AND transaction_status_code = 'PENDING'
7913: AND wda.delivery_detail_id = wdd1.delivery_detail_id
7914: AND NVL(wdd.line_direction,'O') IN ('O','IO')
7915: AND wdd1.source_header_id = l_order_header_id
7916: AND NOT EXISTS
7917: (SELECT lpn_id FROM rcv_transactions_interface
7918: WHERE lpn_id = wdd.lpn_id
7919: AND transaction_status_code = 'PENDING'
7920: AND processing_status_code <> 'ERROR')
7921: AND ROWNUM = 1;
7950: SELECT rsl.asn_lpn_id
7951: FROM rcv_shipment_lines rsl
7952: WHERE rsl.shipment_header_id = rsh.shipment_header_id
7953: AND NOT exists (SELECT 1
7954: FROM rcv_transactions_interface rti
7955: WHERE rti.lpn_id = rsl.asn_lpn_id
7956: AND rti.transfer_lpn_id = rsl.asn_lpn_id
7957: AND rti.to_organization_id = rsl.to_organization_id
7958: AND rti.processing_status_code <> 'ERROR'
8168: l_progress := '20';
8169: BEGIN
8170: SELECT DISTINCT mum.uom_code
8171: INTO l_uom_code
8172: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum
8173: WHERE rt.transaction_type = 'RECEIVE'
8174: AND rsl.item_id = p_item_id
8175: AND rt.organization_id = p_organization_id
8176: AND rsl.shipment_header_id = rt.shipment_header_id