APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_HEADERS_ALL

Line 180: PO_HEADERS_ALL PH,

176: FROM (
177: SELECT DISTINCT PH.SEGMENT1 || DECODE(PR.RELEASE_NUM, NULL, '', '-' || PR.RELEASE_NUM) ORDER_NUM
178: FROM PO_REQUISITION_LINES_ALL PRL,
179: PO_LINE_LOCATIONS_ALL PLL,
180: PO_HEADERS_ALL PH,
181: PO_RELEASES_ALL PR
182: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
183: PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
184: PLL.PO_RELEASE_ID = PR.PO_RELEASE_ID(+) AND

Line 219: PO_HEADERS_ALL PH,

215: FROM (
216: SELECT DISTINCT PV.VENDOR_NAME SUPPLIER
217: FROM PO_REQUISITION_LINES_ALL PRL,
218: PO_LINE_LOCATIONS_ALL PLL,
219: PO_HEADERS_ALL PH,
220: PO_VENDORS PV
221: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND
222: PLL.PO_HEADER_ID = PH.PO_HEADER_ID AND
223: PH.VENDOR_ID = PV.VENDOR_ID AND