ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E751A9E05362FB09050512 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) PQH PQIPED10_XML US PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part A(obsoleted) 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 BI Publisher :cp_fr :cp_ft :cp_pr :cp_pt :lastlineno :line_num :p_business_group_id :p_conc_request_id :p_report_date :tottitle 1 -20 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group ID Business Group ID 2 10 :p_report_date Date Y US Reporting Date Reporting Date