ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2BC3869E053B46B63588994 SELECT substr(p.name,1,60) organization_name, hr.meaning type, pal2.meaning internal_external, substr(hrltl.location_code,1,20) location FROM hr_lookups hr, hr_lookups pal2, hr_locations_all hrl, hr_locations_all_tl hrltl, pa_implementations pi, hr_organization_units p WHERE p.business_group_id = pi.business_group_id and pal2.lookup_type (+) = 'INTL_EXTL' and pal2.lookup_code (+) = p.internal_external_flag and hrl.location_id (+) = p.location_id and hrltl.location_id(+) = hrl.location_id and hrltl.language(+) = userenv('LANG') and hr.lookup_code (+) = p.type and hr.lookup_type (+) = 'ORG_TYPE' and ((:p_type is null) or p.type = nvl(:p_type,p.type)) ORDER BY p.name Y PA PAXPEORG_XML AR PA قائمة التنظيم (بتنسيق XML) Application: المشروعات Source: IMP: قائمة التنظيم (بتنسيق XML) Short Name: PAXPEORG_XML DB package: PA_PAXPEORG_XMLP_PKG D PA Organisationen Application: Projects Source: IMP: Organisationen (XML) Short Name: PAXPEORG_XML DB package: PA_PAXPEORG_XMLP_PKG F PA Liste des organisations Application: Projects Source: IMP : Liste des organisations (XML) Short Name: PAXPEORG_XML DB package: PA_PAXPEORG_XMLP_PKG US PA Organization Listing Application: Projects Source: IMP: Organization Listing (XML) Short Name: PAXPEORG_XML DB package: PA_PAXPEORG_XMLP_PKG ZHS PA IMP：组织列表 Application: 项目 Source: IMP：组织列表 (XML) Short Name: PAXPEORG_XML DB package: PA_PAXPEORG_XMLP_PKG BI Publisher :c_company_name_header :c_type_meaning :operating_unit :p_conc_request_id :p_type 1 10 :p_type LOV Oracle PA_SRS_ORG_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='ORG_TYPE' order by meaning AR نوع التنظيم D Organisationsart F Type d'organisation US Organization Type ZHS 组织类型