GHR CPDF Organizational Component Translation

➜ Back to Library
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
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
Download
Related Blitz Reports
GHR CPDF Dynamics GHR CPDF Status GL Currency - Historical Rates Listing ECC Depot Repair, Depot Service Orders INV Move Order Pick Slip WSH Pick Slip CST Margin Analysis Report with Order Management ECC Payables, Installments, SQL1 ECC Depot Repair, Depot Resolved Service Orders
Blitz Report™

Blitz Report™ provides multiple benefits: