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_REQUISITION_LINES_ALL

Line 323: po_requisition_lines_all PRL,

319: BEGIN
320: SELECT count(*)
321: INTO l_cto_order
322: FROM po_requisition_headers_all PRH,
323: po_requisition_lines_all PRL,
324: po_line_locations_all POLL
325: WHERE PRH.interface_source_code = 'CTO'
326: AND PRH.requisition_header_id = PRL.requisition_header_id
327: AND PRL.line_location_id = POLL.line_location_id

Line 540: FROM po_requisition_lines_all porl, --

536: -- SQL What: Querying backing requisiton line IDs of this release
537: -- SQL Why: Need to cancel or recreate these backing reqs
538: -- SQL Join: line_location_id
539: SELECT porl.requisition_line_id
540: FROM po_requisition_lines_all porl, --
541: po_line_locations poll
542: WHERE poll.po_release_id = p_doc_id AND
543: poll.line_location_id = porl.line_location_id AND
544: NVL(poll.cancel_flag, 'N') = 'N' AND