DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 228: HR_ALL_ORGANIZATION_UNITS_TL HAOU

224: PRL.REQUISITION_HEADER_ID = pReqHeaderId
225: UNION ALL
226: SELECT DISTINCT HAOU.NAME SUPPLIER
227: FROM PO_REQUISITION_LINES_ALL PRL,
228: HR_ALL_ORGANIZATION_UNITS_TL HAOU
229: WHERE PRL.SOURCE_TYPE_CODE = 'INVENTORY' AND
230: HAOU.ORGANIZATION_ID = PRL.SOURCE_ORGANIZATION_ID AND
231: HAOU.LANGUAGE = USERENV('LANG') AND
232: PRL.REQUISITION_HEADER_ID = pReqHeaderId