PA Job Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: IMP: Job Listing (XML)
Short Name: PAXPEJOB_XML
DB package: PA_PAXPEJOB_XMLP_PKG
Run PA Job Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT
	decode(:p_sort_by,
		'JOB LEVEL', jd.segment1,
		'JOB DISCIPLINE', jd.segment2,
		j.name) sort_by_value,
        jd.segment1 job_level,
        jd.segment2 job_discipline,
	j.name,
	j.comments,
	j.date_from,
	j.date_to
FROM
	per_jobs j,
	per_job_definitions jd,
        pa_implementations pi
  WHERE j.business_group_id = pi.business_group_id and j.job_definition_id = jd.job_definition_id and nvl ( jd.segment1 , 'zzz' ) = nvl ( :p_job_level , nvl ( jd.segment1 , 'zzz' ) ) and nvl ( jd.segment2 , 'zzz' ) = nvl ( :p_job_discipline , nvl ( jd.segment2 , 'zzz' ) )
  ORDER BY 1 ASC,2 ASC , j.name
Parameter Name SQL text Validation
Sort Jobs By 
 
 LOV Oracle
Job Level 
 
 LOV Oracle
Job Discipline 
 
 LOV Oracle
Download
Related Blitz Reports
PA Employee Assignments By Organization PA Employee Assignment WIP Required Components PA Labor Cost Rates Listing By Organization PA Labor Cost Rates Listing CAC Receiving Value (Period-End) ECC Projects, Projects Costing: Transactions, SQL1 WIP Account Distribution ECC Project Manufacturing, Expenditures
Blitz Report™

Blitz Report™ provides multiple benefits: