[Home] [Help]
2682: --If no MOL found, then get project and task from RTI
2683: BEGIN
2684: SELECT project_id,task_id
2685: INTO l_project_id,l_task_id
2686: FROM rcv_transactions_interface
2687: WHERE transfer_lpn_id = p_lpn_id
2688: AND transaction_type = 'RECEIVE'
2689: AND transaction_status_code = 'PENDING'
2690: AND processing_status_code <> 'ERROR'
3707: /* Two new parameter x_lpn_context and x_default_source have been added
3708: * to return the lpn_context and a flag that indicates how the
3709: * subinventory and locator have been defaulted. Possible values are:
3710: * LPN -> Sub and locator are derived from WMS_LICENSE_PLATE_NUMBERS
3711: * RTI -> Sub and locator are derived from RCV_TRANSACTIONS_INTERFACE
3712: * DOC -> Sub and locator are derived from document (POD/RSL/REQ)
3713: * ITD -> Sub and locator are derived from item transaction defaults
3714: * NONE -> There is no default sub and locator being returned
3715: * This validation is applicable only if INV and PO patch levels are J or
3812: IF (l_debug = 1) THEN
3813: print_debug('get_sub_code: WMS and PO are J or higher: should also check for sub/loc from RTI', 4);
3814: END IF;
3815:
3816: --Get the subinventory, locator_id and routing from rcv_transactions_interface
3817: --If there exists one and it is not direct then error out with the
3818: --"Invalid LPN context" error since we cannot commingle routings in the same LPN
3819: BEGIN
3820: SELECT NVL(subinventory, '@@@')
3822: , auto_transact_code
3823: INTO x_sub_code
3824: , l_locator_id
3825: , l_auto_transact_code
3826: FROM rcv_transactions_interface
3827: WHERE transfer_lpn_id = p_lpn_id
3828: AND transaction_type = 'RECEIVE'
3829: AND transaction_status_code = 'PENDING'
3830: AND processing_status_code <> 'ERROR'
5740: WHERE item_id = p_item_id
5741: AND to_organization_id = p_organization_id
5742: AND EXISTS(
5743: SELECT 1
5744: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
5745: WHERE prl.requisition_header_id = p_requiition_header_id
5746: AND rsl.requisition_line_id = prl.requisition_line_id
5747: AND prl.item_id = p_item_id
5748: AND prl.source_type_code = 'INVENTORY'
5755: AND rt.organization_id = p_organization_id
5756: AND(
5757: EXISTS(
5758: SELECT 1
5759: FROM rcv_transactions rt1
5760: WHERE rt1.transaction_id = rt.transaction_id
5761: AND rt1.inspection_status_code <> 'NOT INSPECTED'
5762: AND rt1.routing_header_id = 2)
5763: OR rt.routing_header_id <> 2
5903: WHERE item_id = p_item_id
5904: AND to_organization_id = p_organization_id
5905: AND EXISTS(
5906: SELECT 1
5907: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
5908: WHERE prl.requisition_header_id = p_requiition_header_id
5909: AND rsl.requisition_line_id = prl.requisition_line_id
5910: AND prl.item_id = p_item_id
5911: AND prl.source_type_code = 'INVENTORY'
5917: AND rs.to_organization_id = p_organization_id
5918: AND rt.organization_id = p_organization_id
5919: AND(EXISTS(
5920: SELECT 1
5921: FROM rcv_transactions rt1
5922: WHERE rt1.transaction_id = rt.transaction_id
5923: AND rt1.inspection_status_code = 'NOT INSPECTED'
5924: AND rt1.routing_header_id = 2)
5925: ));
6953: -- Retrieval of x_lpn_flag is changed
6954: --
6955: SELECT 'Y'
6956: INTO x_lpn_flag
6957: FROM wms_license_plate_numbers lpn, wms_lpn_contents wlc, rcv_transactions_interface rti
6958: WHERE lpn.lpn_id = wlc.parent_lpn_id
6959: AND lpn.lpn_id = rti.lpn_id
6960: AND rti.transaction_status_code = 'PENDING'
6961: AND lpn.lpn_id IN(SELECT lpn_id
7045:
7046: IF l_sub_code IS NULL THEN
7047: BEGIN
7048: l_progress := '30';
7049: --Get the subinventory, locator_id and routing from rcv_transactions_interface
7050: --If there exists one and it is not direct then error out with the
7051: --"Invalid LPN context" error since we cannot commingle routings in the same LPN
7052: SELECT subinventory
7053: , locator_id
7056: INTO l_sub_code
7057: , l_locator_id
7058: , l_location_id
7059: , l_auto_transact_code
7060: FROM rcv_transactions_interface
7061: WHERE transfer_lpn_id = p_lpn_id
7062: AND transaction_type = 'RECEIVE'
7063: AND transaction_status_code = 'PENDING'
7064: AND processing_status_code <> 'ERROR'
7229: -- Check if there is any existing RTI Record for the given LPN or their childs.
7230:
7231: BEGIN
7232: SELECT 'N' INTO x_lpn_flag
7233: FROM rcv_transactions_interface
7234: WHERE lpn_id IN ( SELECT lpn_id FROM wms_license_plate_numbers
7235: START WITH lpn_id = p_lpn_id
7236: CONNECT BY parent_lpn_id = PRIOR lpn_id)
7237: AND transaction_status_code = 'PENDING'
7381: AND wda.delivery_detail_id = wdd1.delivery_detail_id
7382: AND NVL(wdd.line_direction,'O') IN ('O','IO')
7383: AND wdd1.source_header_id = l_order_header_id
7384: AND NOT EXISTS
7385: (SELECT lpn_id FROM rcv_transactions_interface
7386: WHERE lpn_id = wdd.lpn_id
7387: AND transaction_status_code = 'PENDING'
7388: AND processing_status_code <> 'ERROR')
7389: AND ROWNUM = 1;
7418: SELECT rsl.asn_lpn_id
7419: FROM rcv_shipment_lines rsl
7420: WHERE rsl.shipment_header_id = rsh.shipment_header_id
7421: AND NOT exists (SELECT 1
7422: FROM rcv_transactions_interface rti
7423: WHERE rti.lpn_id = rsl.asn_lpn_id
7424: AND rti.transfer_lpn_id = rsl.asn_lpn_id
7425: AND rti.to_organization_id = rsl.to_organization_id
7426: AND rti.processing_status_code <> 'ERROR'
7636: l_progress := '20';
7637: BEGIN
7638: SELECT DISTINCT mum.uom_code
7639: INTO l_uom_code
7640: FROM rcv_transactions rt , rcv_shipment_lines rsl, mtl_units_of_measure mum
7641: WHERE rt.transaction_type = 'RECEIVE'
7642: AND rsl.item_id = p_item_id
7643: AND rt.organization_id = p_organization_id
7644: AND rsl.shipment_header_id = rt.shipment_header_id