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.POR_RCV_POST_QUERY_PKG dependencies on PO_REQUISITION_HEADERS

Line 100: from po_requisition_headers a,

96: BEGIN
97: begin
98: select a.segment1, a.requisition_header_id
99: into pReqNum, pReqHeaderId
100: from po_requisition_headers a,
101: po_requisition_lines b
102: where a.requisition_header_id = b.requisition_header_id
103: and b.requisition_line_id = pReqLineId;
104: exception

Line 122: from po_requisition_headers prh,

118: BEGIN
119: begin
120: select prh.segment1,prl.requisition_line_id,prh.requisition_header_id
121: into pReqNum, pReqLineId, pReqHeaderId
122: from po_requisition_headers prh,
123: po_requisition_lines prl,
124: po_distributions pod,
125: po_req_distributions pord
126: where pod.po_distribution_id= pDistributionId

Line 188: FROM PO_REQUISITION_HEADERS_ALL PORH,

184: PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
185: PRL.REQUISITION_HEADER_ID = pReqHeaderId
186: UNION ALL
187: SELECT DISTINCT to_char(OSH.ORDER_NUMBER) ORDER_NUM
188: FROM PO_REQUISITION_HEADERS_ALL PORH,
189: PO_REQUISITION_LINES_ALL PORL,
190: OE_ORDER_HEADERS OSH,
191: PO_SYSTEM_PARAMETERS POSP
192: WHERE PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND