[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