APPS.INV_RCV_INTEGRATION_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 3657: from PO_LINE_LOCATIONS_ALL POLL

3653: End if;
3654: BEGIN
3655: select 1
3656: into l_same_doc
3657: from PO_LINE_LOCATIONS_ALL POLL
3658: where POLL.LINE_LOCATION_ID = p_old_reference_id
3659: and POLL.PO_HEADER_ID in ( select POLL1.PO_HEADER_ID
3660: from PO_LINE_LOCATIONS_ALL POLL1
3661: where POLL1.LINE_LOCATION_ID

Line 3660: from PO_LINE_LOCATIONS_ALL POLL1

3656: into l_same_doc
3657: from PO_LINE_LOCATIONS_ALL POLL
3658: where POLL.LINE_LOCATION_ID = p_old_reference_id
3659: and POLL.PO_HEADER_ID in ( select POLL1.PO_HEADER_ID
3660: from PO_LINE_LOCATIONS_ALL POLL1
3661: where POLL1.LINE_LOCATION_ID
3662: = p_new_reference_id )
3663: and rownum < 2;
3664:

Line 3717: FROM rcv_shipment_lines rsl, po_line_locations_all poll

3713: If l_asn_line_flag = 'Y' then
3714: -- CASE FOR ASN
3715: SELECT 1
3716: INTO l_same_doc
3717: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3718: WHERE rsl.shipment_line_id = p_old_reference_id
3719: AND poll.line_location_id = rsl.po_line_location_id
3720: AND poll.po_header_id in ( select poll1.po_header_id
3721: from rcv_shipment_lines rsl1, po_line_locations_all poll1

Line 3721: from rcv_shipment_lines rsl1, po_line_locations_all poll1

3717: FROM rcv_shipment_lines rsl, po_line_locations_all poll
3718: WHERE rsl.shipment_line_id = p_old_reference_id
3719: AND poll.line_location_id = rsl.po_line_location_id
3720: AND poll.po_header_id in ( select poll1.po_header_id
3721: from rcv_shipment_lines rsl1, po_line_locations_all poll1
3722: where rsl1.shipment_line_id = p_new_reference_id
3723: and poll1.line_location_id = rsl1.po_line_location_id )
3724: AND rownum < 2;
3725: l_progress := 'WMSINB-40411';

Line 9272: FROM po_line_locations_all

9268:
9269: BEGIN
9270: SELECT po_header_id
9271: INTO l_po_header_id
9272: FROM po_line_locations_all
9273: WHERE line_location_id = l_rti_rec.po_line_location_id;
9274: EXCEPTION
9275: WHEN OTHERS THEN
9276: IF (l_debug = 1) THEN

Line 9822: FROM po_line_locations_all

9818: IF (l_rti_rec.po_line_location_id IS NOT NULL) THEN
9819: BEGIN
9820: SELECT po_header_id
9821: INTO l_po_header_id
9822: FROM po_line_locations_all
9823: WHERE line_location_id = l_rti_rec.po_line_location_id;
9824: EXCEPTION
9825: WHEN OTHERS THEN
9826: IF (l_debug = 1) THEN