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 191: FROM PO_REQUISITION_HEADERS_ALL PORH,

187: PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND
188: PRL.REQUISITION_HEADER_ID = pReqHeaderId
189: UNION ALL
190: SELECT DISTINCT TO_CHAR(oe_order_import_interop_pub.Get_Order_Number(POSP.order_source_id,PORL.requisition_header_id,PORL.requisition_line_id)) ORDER_NUM
191: FROM PO_REQUISITION_HEADERS_ALL PORH,
192: PO_REQUISITION_LINES_ALL PORL,
193: PO_SYSTEM_PARAMETERS POSP
194: WHERE PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND
195: PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID AND