APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_HEADERS_ALL

Line 183: PO_HEADERS_ALL PH,

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

Line 224: PO_HEADERS_ALL PH,

220: FROM (
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