APPS.PO_CHG_REQUEST_PVT dependencies on RCV_SHIPMENT_LINES

Line 3601: FROM RCV_SHIPMENT_LINES RSL

3597:
3598: IF(p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL) THEN
3599: SELECT count(*)
3600: into l_count_asn
3601: FROM RCV_SHIPMENT_LINES RSL
3602: WHERE RSL.po_header_id = p_po_header_id
3603: AND RSL.po_release_id (+) = p_po_release_id
3604: AND (RSL.po_line_location_id = l_po_change_requests(j).document_line_location_id OR l_po_change_requests(j).document_line_location_id is null)
3605: AND NVL(RSL.quantity_shipped,0) > NVL(RSL.quantity_received,0)

Line 3611: FROM RCV_SHIPMENT_LINES RSL

3607: AND NVL(RSL.SHIPMENT_LINE_STATUS_CODE,'EXPECTED') <> 'CANCELLED';
3608: ELSE
3609: SELECT count(*)
3610: into l_count_asn
3611: FROM RCV_SHIPMENT_LINES RSL
3612: WHERE RSL.po_header_id = p_po_header_id
3613: AND (RSL.po_line_location_id = l_po_change_requests(j).document_line_location_id OR l_po_change_requests(j).document_line_location_id is null)
3614: AND NVL(RSL.quantity_shipped,0) > NVL(RSL.quantity_received,0)
3615: AND NVL(RSL.ASN_LINE_FLAG,'N') = 'Y'

Line 3819: FROM rcv_shipment_lines RSL

3815:
3816: IF( p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL ) THEN
3817: SELECT Count(*)
3818: INTO l_count_asn
3819: FROM rcv_shipment_lines RSL
3820: WHERE RSL.po_header_id = p_po_header_id
3821: AND RSL.po_release_id (+) = p_po_release_id
3822: AND RSL.po_line_location_id =l_po_change_requests(j).document_line_location_id
3823: AND Nvl(RSL.quantity_shipped, 0) > Nvl(RSL.quantity_received, 0)

Line 3829: FROM rcv_shipment_lines RSL

3825: AND Nvl(RSL.shipment_line_status_code, 'EXPECTED') <>'CANCELLED';
3826: ELSE
3827: SELECT Count(*)
3828: INTO l_count_asn
3829: FROM rcv_shipment_lines RSL
3830: WHERE RSL.po_header_id = p_po_header_id
3831: AND RSL.po_line_location_id = l_po_change_requests(j).document_line_location_id
3832: AND Nvl(RSL.quantity_shipped, 0) > Nvl(RSL.quantity_received, 0)
3833: AND Nvl(RSL.asn_line_flag, 'N') = 'Y'

Line 3892: FROM rcv_shipment_lines RSL

3888:
3889: IF( p_po_header_id IS NOT NULL AND p_po_release_id IS NOT NULL ) THEN
3890: SELECT Count(*)
3891: INTO l_count_asn
3892: FROM rcv_shipment_lines RSL
3893: WHERE RSL.po_header_id = p_po_header_id
3894: AND RSL.po_release_id (+) = p_po_release_id
3895: AND RSL.po_line_location_id = ship_rec.line_location_id
3896: AND Nvl(RSL.quantity_shipped, 0) > Nvl(RSL.quantity_received, 0)

Line 3902: FROM rcv_shipment_lines RSL

3898: AND Nvl(RSL.shipment_line_status_code, 'EXPECTED') <>'CANCELLED';
3899: ELSE
3900: SELECT Count(*)
3901: INTO l_count_asn
3902: FROM rcv_shipment_lines RSL
3903: WHERE RSL.po_header_id = p_po_header_id
3904: AND RSL.po_line_location_id = ship_rec.line_location_id
3905: AND Nvl(RSL.quantity_shipped, 0) > Nvl(RSL.quantity_received, 0)
3906: AND Nvl(RSL.asn_line_flag, 'N') = 'Y'