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_REQ_DISTRIBUTIONS_ALL

Line 490: FROM po_req_distributions_all prd,

486: -- SQL Why: Need to cancel or recreate these backing reqs
487: --: rewrote this SQL state to use the tie between
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

Line 507: FROM po_req_distributions_all prd,

503: -- SQL Why: Need to cancel or recreate these backing reqs
504: --: rewrote this SQL state to use the tie between
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

Line 524: FROM po_req_distributions_all prd,

520: -- SQL Why: Need to cancel or recreate these backing reqs
521: --: rewrote this SQL state to use the tie between
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