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_CHANGEORDERWF_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 7636: po_requisition_lines_all porl,

7632: -- curosr to get the ReqHeaderId
7633: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
7634: select distinct porh.requisition_header_id
7635: from po_requisition_headers_all porh,
7636: po_requisition_lines_all porl,
7637: po_headers_all poh,
7638: po_line_locations_all poll
7639: where porh.requisition_header_id = porl.requisition_header_id AND
7640: porl.line_location_id = poll.line_location_id AND

Line 8096: from po_requisition_lines_all porla,

8092: PROCEDURE getReqNumber(p_po_header_id in number , p_po_release_id in number, x_req_num out nocopy varchar2, x_req_hdr_id out nocopy varchar2) -- RDP(backing)
8093: IS
8094: CURSOR getReqHdrId(c_po_header_id in NUMBER) IS
8095: select distinct(porla.requisition_header_id)
8096: from po_requisition_lines_all porla,
8097: po_line_locations_all polla
8098: where polla.po_header_id = c_po_header_id
8099: and porla.line_location_id = polla.line_location_id;
8100:

Line 8109: from po_requisition_lines_all porla,

8105:
8106: -- for releases
8107: CURSOR getReqHdrId_rel(c_po_header_id in NUMBER, c_po_release_id in NUMBER) IS
8108: select distinct(porla.requisition_header_id)
8109: from po_requisition_lines_all porla,
8110: po_line_locations_all polla
8111: where polla.po_header_id = c_po_header_id
8112: and polla.po_release_id = c_po_release_id
8113: and porla.line_location_id = polla.line_location_id;