APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_VENDORS

Line 215: (select DISTINCT PV.VENDOR_NAME SUPPLIER FROM PO_CLMREQ_LINE_AWD_REFS_V PH, PO_VENDORS PV

211: BEGIN
212:
213: IF pFederalFlag = 'Y' THEN
214: select SUPPLIER into xSupplier from
215: (select DISTINCT PV.VENDOR_NAME SUPPLIER FROM PO_CLMREQ_LINE_AWD_REFS_V PH, PO_VENDORS PV
216: where PH.VENDOR_ID = PV.VENDOR_ID AND PH.requisition_header_id=pReqHeaderId );
217: ELSE
218: SELECT SUPPLIER
219: INTO xSupplier

Line 225: PO_VENDORS PV

221: SELECT DISTINCT PV.VENDOR_NAME SUPPLIER
222: FROM PO_REQUISITION_LINES_ALL PRL,
223: PO_LINE_LOCATIONS_ALL PLL,
224: PO_HEADERS_ALL PH,
225: PO_VENDORS PV
226: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
227: PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
228: PH.VENDOR_ID = PV.VENDOR_ID AND
229: PRL.REQUISITION_HEADER_ID = pReqHeaderId