ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFB63869E053B46B63588994 SELECT AGENCY, COMPONENT, TITLE, MIN(L_COUNT) FROM (SELECT FROM_BASIC_PAY SORT_BY, AGENCY_CODE AGENCY, ORGANIZATIONAL_COMPONENT COMPONENT, LPAD(' ',2 * (FROM_LOCALITY_ADJ - 1)) ||RPAD(FROM_OCC_CODE ||FROM_NATIONAL_IDENTIFIER,179,' ') TITLE, NVL(FROM_LOCALITY_ADJ,0) L_LEVEL, FROM_BASIC_PAY L_COUNT FROM GHR_CPDF_TEMP WHERE REPORT_TYPE = 'GHRCPDFO' AND SESSION_ID = USERENV('sessionid') order by L_COUNT ) GROUP BY AGENCY,COMPONENT,TITLE ORDER BY 4 Y GHR GHRCPDFO_XML US GHR CPDF Organizational Component Translation Application: US Federal Human Resources Source: CPDF Organizational Component Translation Report (XML) Short Name: GHRCPDFO_XML DB package: GHR_GHRCPDFO_XMLP_PKG BI Publisher :filename :p_agency_code :p_agency_subelement :p_conc_request_id :p_hierarchy_version :p_organization_hierarchy :p_report_date 1 10 :p_report_date Date Y US Report Date 2 20 :p_agency_code LOV Oracle GHR_US_AGENCY_CODE_2 Y Y select lookup_code id, lookup_code value, meaning description from hr_lookups hrl,fnd_sessions s where s.session_id=userenv('sessionid') and hrl.lookup_type='GHR_US_AGENCY_CODE_2' and hrl.enabled_flag='Y' and s.effective_date between nvl(start_date_active,s.effective_date) and nvl(end_date_active,s.effective_date) order by hrl.lookup_code Y US Agency Code 3 30 :p_agency_subelement LOV Oracle GHR_US_AGENCY_SUBELEMENT Y Y select substr(lookup_code,3) id, substr(lookup_code,3) value, meaning description from hr_lookups hrl,fnd_sessions s where s.session_id=userenv('sessionid') and hrl.lookup_type='GHR_US_AGENCY_CODE' and hrl.enabled_flag='Y' and lookup_code like :$flex$.ghr_us_agency_code_2 || '%' and s.effective_date between nvl(start_date_active,s.effective_date) and nvl(end_date_active,s.effective_date) order by substr(hrl.lookup_code,3) US Subelement 4 40 :p_organization_hierarchy LOV Oracle PER_ORG_STRUCTS Y select s.organization_structure_id id, s.name value, null description from per_organization_structures s where s.business_group_id=fnd_global.per_business_group_id order by value,description US Name of Organization Hierarchy 5 50 :p_hierarchy_version LOV Oracle PER_ORG_STRUCT_VERS Y select v.org_structure_version_id id, to_char(v.version_number) value, fnd_date.date_to_chardate(v.date_from) || decode(v.date_to,null,null,' -> '||fnd_date.date_to_chardate(v.date_to)) description from per_org_structure_versions v where v.organization_structure_id=:$flex$.per_org_structs order by v.date_from desc Y US Organization Hierarchy Version Number 6 60 :filename Char US Report Filename