PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part B(obsoleted)

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: IPEDS Report - Non-Degree Granting Institutions (S2) - Part B (XML) (obsoleted)
Short Name: PQIPED11_XML
DB package: PQH_PQIPED11_XMLP_PKG
Run PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part B(obsoleted) and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT jobcode,
     meaning, PQH_PQIPED11_XMLP_PKG.line_noformula() line_no, rownum
   FROM
     (SELECT hl.lookup_code jobcode, to_number(hl.lookup_code) jobcode1, hl.meaning meaning
      FROM hr_lookups hl
      WHERE hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES'
      AND lookup_code NOT IN('1',    '2',    '3',    '12')
   ORDER BY 2)
/*select hl.lookup_code jobCode,
hl.meaning, 
	PQH_PQIPED11_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
Download
Related Blitz Reports
CAC Shipping Network (Inter-Org) Accounts Setup CAC WIP Accounts Setup AR Profile Option Migration CAC Subinventory Accounts Setup CAC Purchase Price Variance CAC ICP PII WIP Pending Cost Adjustment CAC WIP Pending Cost Adjustment CAC Item List Price vs. Item Cost CAC Category Accounts Setup CAC Calculate ICP PII Item Costs
Blitz Report™

Blitz Report™ provides multiple benefits: