GHR CPDF Organizational Component Translation
Description
Categories: BI Publisher
Application: US Federal Human Resources
Source: CPDF Organizational Component Translation Report (XML)
Short Name: GHRCPDFO_XML
DB package: GHR_GHRCPDFO_XMLP_PKG
Source: CPDF Organizational Component Translation Report (XML)
Short Name: GHRCPDFO_XML
DB package: GHR_GHRCPDFO_XMLP_PKG
Run
GHR CPDF Organizational Component Translation and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Report Date |
|
Date | |
Agency Code |
|
LOV Oracle | |
Subelement |
|
LOV Oracle | |
Name of Organization Hierarchy |
|
LOV Oracle | |
Organization Hierarchy Version Number |
|
LOV Oracle | |
Report Filename |
|
Char |