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_CANCEL_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 492: po_distributions_all pod

488: --PO dist and Req dist instead of Req line to PO line loc.
489: SELECT DISTINCT(prd.requisition_line_id)
490: FROM po_req_distributions_all prd,
491: po_line_locations_all poll,
492: po_distributions_all pod
493: WHERE pod.line_location_id = p_doc_line_loc_id
494: AND pod.line_location_id = poll.line_location_id
495: AND pod.req_distribution_id = prd.distribution_id
496: AND NVL(poll.cancel_flag, 'N') = 'N'

Line 509: po_distributions_all pod

505: --PO dist and Req dist instead of Req line to PO line loc.
506: SELECT DISTINCT(prd.requisition_line_id)
507: FROM po_req_distributions_all prd,
508: po_line_locations_all poll,
509: po_distributions_all pod
510: WHERE pod.po_line_id = p_doc_line_id
511: AND pod.line_location_id = poll.line_location_id
512: AND pod.req_distribution_id = prd.distribution_id
513: AND NVL(poll.cancel_flag, 'N') = 'N'

Line 526: po_distributions_all pod

522: --PO dist and Req dist instead of Req line to PO line loc.
523: SELECT DISTINCT(prd.requisition_line_id)
524: FROM po_req_distributions_all prd,
525: po_line_locations_all poll,
526: po_distributions_all pod
527: WHERE pod.po_header_id = p_doc_id
528: AND pod.line_location_id = poll.line_location_id
529: AND pod.req_distribution_id = prd.distribution_id
530: AND NVL(poll.cancel_flag, 'N') = 'N'