eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on RCV_SHIPMENT_LINES

Line 19659: FROM rcv_shipment_lines rsl

19655: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19656: AND EXISTS
19657: (
19658: SELECT 'ASN outstanding'
19659: FROM rcv_shipment_lines rsl
19660: WHERE rsl.po_line_location_id = poll.line_location_id
19661: AND NVL(rsl.quantity_shipped, 0) > NVL(rsl.quantity_received, 0)
19662: AND NVL(rsl.asn_line_flag, 'N') = 'Y'
19663: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') <> 'CANCELLED'

Line 19707: FROM rcv_shipment_lines rsl

19703: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19704: AND EXISTS
19705: (
19706: SELECT 'ASN outstanding'
19707: FROM rcv_shipment_lines rsl
19708: WHERE rsl.po_release_id = por.po_release_id
19709: AND NVL(rsl.quantity_shipped, 0) > NVL(rsl.quantity_received, 0)
19710: AND NVL(rsl.asn_line_flag, 'N') = 'Y'
19711: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') <> 'CANCELLED'

Line 19769: FROM rcv_shipment_lines rsl

19765: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19766: AND EXISTS
19767: (
19768: SELECT 'ASN outstanding'
19769: FROM rcv_shipment_lines rsl
19770: WHERE rsl.po_line_id = pol.po_line_id
19771: AND NVL(rsl.quantity_shipped, 0) > NVL(rsl.quantity_received, 0)
19772: AND NVL(rsl.asn_line_flag, 'N') = 'Y'
19773: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') <> 'CANCELLED'

Line 19831: FROM rcv_shipment_lines rsl

19827: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
19828: AND EXISTS
19829: (
19830: SELECT 'ASN outstanding'
19831: FROM rcv_shipment_lines rsl
19832: WHERE rsl.po_line_location_id = poll.line_location_id
19833: AND NVL(rsl.quantity_shipped, 0) > NVL(rsl.quantity_received, 0)
19834: AND NVL(rsl.asn_line_flag, 'N') = 'Y'
19835: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') <> 'CANCELLED'

Line 19883: FROM rcv_shipment_lines rsl

19879: )
19880: AND EXISTS
19881: (
19882: SELECT 'ASN outstanding'
19883: FROM rcv_shipment_lines rsl
19884: WHERE rsl.po_line_location_id = poll.line_location_id
19885: AND NVL(rsl.quantity_shipped, 0) > NVL(rsl.quantity_received, 0)
19886: AND NVL(rsl.asn_line_flag, 'N') = 'Y'
19887: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') <> 'CANCELLED'