DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 233: HR_ALL_ORGANIZATION_UNITS_TL HAOU

229: PRL.REQUISITION_HEADER_ID = pReqHeaderId
230: UNION ALL
231: SELECT DISTINCT HAOU.NAME SUPPLIER
232: FROM PO_REQUISITION_LINES_ALL PRL,
233: HR_ALL_ORGANIZATION_UNITS_TL HAOU
234: WHERE PRL.SOURCE_TYPE_CODE = 'INVENTORY' AND
235: HAOU.ORGANIZATION_ID = PRL.SOURCE_ORGANIZATION_ID AND
236: HAOU.LANGUAGE = USERENV('LANG') AND
237: PRL.REQUISITION_HEADER_ID = pReqHeaderId