PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part A(obsoleted)
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: IPEDS Report - Non-Degree Granting Institutions (S2) - Part A (XML) (obsoleted)
Short Name: PQIPED10_XML
DB package: PQH_PQIPED10_XMLP_PKG
Application: Public Sector HR
Source: IPEDS Report - Non-Degree Granting Institutions (S2) - Part A (XML) (obsoleted)
Short Name: PQIPED10_XML
DB package: PQH_PQIPED10_XMLP_PKG
Run
PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part A(obsoleted) and other Oracle EBS reports with Blitz Report™ on our demo environment
select jobCode,meaning,PQH_PQIPED10_XMLP_PKG.line_noformula() line_no,rownum from ( select hl.lookup_code jobCode, hl.meaning, PQH_PQIPED10_XMLP_PKG.line_noformula() line_no from hr_lookups hl where hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES' and lookup_code not in ('1','2','3','12') order by to_number(hl.lookup_code)) --select hl.lookup_code jobCode, --hl.meaning, -- PQH_PQIPED10_XMLP_PKG.line_noformula() line_no --from hr_lookups hl --where hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES' --and lookup_code not in ('1','2','3','12') --order by to_number(hl.lookup_code) |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Reporting Date |
|
Date |
Blitz Report™