APPS.INV_RCV_INTEGRATION_PVT dependencies on PO_LINE_LOCATIONS

Line 2310: FROM po_line_locations pll, po_headers ph, po_lines pl,

2306: BEGIN
2307: --performace fix. Bug 3444172. Modified the query below.
2308: SELECT DISTINCT pll.ship_to_organization_id
2309: INTO l_rti_rec.to_organization_id
2310: FROM po_line_locations pll, po_headers ph, po_lines pl,
2311: mtl_system_items_kfv msik
2312: WHERE ph.segment1 = l_rti_rec.document_num
2313: AND ((msik.inventory_item_id = l_rti_rec.item_id)
2314: OR (msik.concatenated_segments = l_rti_rec.item_num

Line 3712: from PO_LINE_LOCATIONS_ALL POLL

3708: End if;
3709: BEGIN
3710: select 1
3711: into l_same_doc
3712: from PO_LINE_LOCATIONS_ALL POLL
3713: where POLL.LINE_LOCATION_ID = p_old_reference_id
3714: and POLL.PO_HEADER_ID in ( select POLL1.PO_HEADER_ID
3715: from PO_LINE_LOCATIONS_ALL POLL1
3716: where POLL1.LINE_LOCATION_ID

Line 3715: from PO_LINE_LOCATIONS_ALL POLL1

3711: into l_same_doc
3712: from PO_LINE_LOCATIONS_ALL POLL
3713: where POLL.LINE_LOCATION_ID = p_old_reference_id
3714: and POLL.PO_HEADER_ID in ( select POLL1.PO_HEADER_ID
3715: from PO_LINE_LOCATIONS_ALL POLL1
3716: where POLL1.LINE_LOCATION_ID
3717: = p_new_reference_id )
3718: and rownum < 2;
3719:

Line 3772: FROM rcv_shipment_lines rsl, po_line_locations_all poll

3768: If l_asn_line_flag = 'Y' then
3769: -- CASE FOR ASN
3770: SELECT 1
3771: INTO l_same_doc
3772: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3773: WHERE rsl.shipment_line_id = p_old_reference_id
3774: AND poll.line_location_id = rsl.po_line_location_id
3775: AND poll.po_header_id in ( select poll1.po_header_id
3776: from rcv_shipment_lines rsl1, po_line_locations_all poll1

Line 3776: from rcv_shipment_lines rsl1, po_line_locations_all poll1

3772: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3773: WHERE rsl.shipment_line_id = p_old_reference_id
3774: AND poll.line_location_id = rsl.po_line_location_id
3775: AND poll.po_header_id in ( select poll1.po_header_id
3776: from rcv_shipment_lines rsl1, po_line_locations_all poll1
3777: where rsl1.shipment_line_id = p_new_reference_id
3778: and poll1.line_location_id = rsl1.po_line_location_id )
3779: AND rownum < 2;
3780: l_progress := 'WMSINB-40411';

Line 9702: FROM po_line_locations_all

9698:
9699: BEGIN
9700: SELECT po_header_id
9701: INTO l_po_header_id
9702: FROM po_line_locations_all
9703: WHERE line_location_id = l_rti_rec.po_line_location_id;
9704: EXCEPTION
9705: WHEN OTHERS THEN
9706: IF (l_debug = 1) THEN

Line 10252: FROM po_line_locations_all

10248: IF (l_rti_rec.po_line_location_id IS NOT NULL) THEN
10249: BEGIN
10250: SELECT po_header_id
10251: INTO l_po_header_id
10252: FROM po_line_locations_all
10253: WHERE line_location_id = l_rti_rec.po_line_location_id;
10254: EXCEPTION
10255: WHEN OTHERS THEN
10256: IF (l_debug = 1) THEN