APPS.INV_UI_RCV_LOVS dependencies on WMS_LPN_CONTENTS

Line 6757: from wms_lpn_contents wlc ,

6753: NVL(DUAL_UOM_DEVIATION_LOW,0),
6754: stock_enabled_flag,
6755: DECODE (p_reqHeaderID,to_char(null),' ', rsh.shipment_num),
6756: DECODE (p_reqHeaderID,to_char(null),' ',p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6757: from wms_lpn_contents wlc ,
6758: mtl_system_items_vl msn, /* Bug 5581528 */
6759: rcv_shipment_lines rsl,
6760: rcv_shipment_headers rsh /* Added for Bug9257750 */
6761: WHERE msn.organization_id = p_Organization_Id

Line 6831: from wms_lpn_contents wlc

6827: DECODE (p_reqHeaderID,to_char(null),' ',
6828: rsh.shipment_num),
6829: DECODE (p_reqHeaderID,to_char(null),' ',
6830: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6831: from wms_lpn_contents wlc
6832: ,po_lines_trx_v pol -- CLM project, bug 9403291
6833: ,mtl_system_items_vl msi /* Bug 5581528 */
6834: ,rcv_shipment_lines rsl
6835: ,rcv_shipment_headers rsh /* Added for Bug9257750 */

Line 7025: from wms_lpn_contents wlc,

7021: DECODE (p_reqHeaderID,to_char(null),' ',
7022: rsh.shipment_num),
7023: DECODE (p_reqHeaderID,to_char(null),' ',
7024: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7025: from wms_lpn_contents wlc,
7026: mtl_system_items_vl msn, /* Bug 5581528 */
7027: rcv_shipment_lines rsl,
7028: rcv_shipment_headers rsh, /* Added for Bug9257750 */
7029: mtl_cross_references mcr

Line 7616: FROM wms_lpn_Contents wlc

7612: AND rsh.shipment_header_id = rsl.shipment_header_id /* Added by Bug9257750 */
7613: AND l_From_lpn_Id IS NOT NULL
7614: AND EXISTS
7615: (SELECT '1'
7616: FROM wms_lpn_Contents wlc
7617: WHERE wlc.Parent_lpn_Id = l_From_lpn_Id
7618: AND wlc.Inventory_Item_Id = rsl.Item_Id
7619: )
7620: AND prl.Requisition_Line_Id = rsl.Requisition_Line_Id

Line 7814: FROM wms_lpn_contents wlc

7810: AND ( (l_from_lpn_id IS NULL)
7811: OR (l_from_lpn_id IS NOT NULL
7812: AND EXISTS
7813: (SELECT '1'
7814: FROM wms_lpn_contents wlc
7815: WHERE wlc.parent_lpn_id = l_from_lpn_id
7816: AND wlc.inventory_item_id = rsl.item_id
7817: ) ) )
7818: AND prl.requisition_line_id = rsl.requisition_line_id

Line 8387: wms_lpn_contents wlc

8383: milk.concatenated_segments,
8384: wlpn.lpn_context
8385: FROM wms_license_plate_numbers wlpn,
8386: mtl_item_locations_kfv milk,
8387: wms_lpn_contents wlc
8388: WHERE wlpn.organization_id = milk.organization_id (+)
8389: AND wlpn.locator_id = milk.inventory_location_id(+)
8390: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
8391: AND wlpn.license_plate_number LIKE p_lpn

Line 8428: wms_lpn_contents wlc

8424: milk.concatenated_segments,
8425: wlpn.lpn_context
8426: FROM wms_license_plate_numbers wlpn,
8427: mtl_item_locations_kfv milk,
8428: wms_lpn_contents wlc
8429: WHERE wlpn.organization_id = milk.organization_id (+)
8430: AND wlpn.locator_id = milk.inventory_location_id(+)
8431: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
8432: AND wlpn.license_plate_number LIKE p_lpn

Line 8469: wms_lpn_contents wlc

8465: INV_PROJECT.GET_TASK_NUMBER,
8466: wlpn.lpn_context
8467: FROM wms_license_plate_numbers wlpn,
8468: mtl_item_locations_kfv milk,
8469: wms_lpn_contents wlc
8470: WHERE wlpn.organization_id = milk.organization_id (+)
8471: AND wlpn.locator_id = milk.inventory_location_id(+)
8472: AND wlc.parent_lpn_id (+) = wlpn.lpn_id
8473: AND wlpn.license_plate_number LIKE p_lpn