PA Project Configuration

SELECT
        p.project_id,
        p.labor_sch_type lab_sch_type_code,
        pal3.meaning labor_sch_type,
        p.non_labor_sch_type nonlab_sch_type_code,
        pal4.meaning non_labor_sch_type,
        irs1.ind_rate_sch_name rev_schedule,
        p.rev_ind_sch_fixed_date rev_fixed_date,
        irs2.ind_rate_sch_name inv_schedule,
        p.inv_ind_sch_fixed_date inv_fixed_date,
        dist.meaning distribution_rule,
        substr(per2tl.name,1,60) labor_bill_rate_org, 
        sc1.std_bill_rate_schedule,  
        pal1.meaning schedule_type,
        p.labor_schedule_discount||
         decode(p.labor_schedule_discount,null,'','%') labor_schedule_discount,
        p.labor_schedule_fixed_date,
        substr(per3tl.name,1,60) non_labor_bill_rate_org, 
        p.non_labor_std_bill_rate_schdl,
	pal2.meaning nl_schedule_type,
        p.non_labor_schedule_discount||
         decode
       (p.non_labor_schedule_discount,null,'','%') non_labor_schedule_discount,
        p.non_labor_schedule_fixed_date,
        ifl.name invoice_labor_format_code,
        ife.name invoice_expense_format_code,
        ifr.name retention_format_code,
        ifb.name retention_billing_format_code,
        p.retention_percentage,
        p.invoice_comment,
        p.output_tax_code,
        p.retention_tax_code,
        decode(nvl(p.retn_accounting_flag,'N'),'Y','Yes','No') enable_enhanced_retn,
        p.baseline_funding_flag,
        p.revaluate_funding_flag,
        p.include_gains_losses_flag,
		rtrim(sc1.std_bill_rate_schedule) emp_bill_rate_schd, 
		rtrim(sc3.std_bill_rate_schedule) job_bill_rate_schd, 
        p.enable_top_task_customer_flag,          p.enable_top_task_inv_mth_flag,            p.revenue_accrual_method,                    p.invoice_method                                  
		FROM
        pa_ind_rate_schedules irs1,
        pa_ind_rate_schedules irs2,
        pa_std_bill_rate_schedules sc1,
        pa_std_bill_rate_schedules sc2,
		pa_std_bill_rate_schedules sc3,  
	    pa_lookups pal1,
	    pa_lookups pal2,
        pa_distribution_rules dist,
        pa_invoice_formats ifl,
        pa_invoice_formats ife,
        pa_invoice_formats ifr,
        pa_invoice_formats ifb,
        hr_org_units_no_join per2,
        hr_all_organization_units_tl per2tl,
        hr_org_units_no_join per3,
        hr_all_organization_units_tl per3tl,
        pa_projects p,
                  pa_lookups pal3,
                  pa_lookups pal4
WHERE
                  (irs1.ind_rate_sch_id (+) = p.rev_ind_rate_sch_id
and            irs2.ind_rate_sch_id (+) = p.inv_ind_rate_sch_id
and	pal3.lookup_code (+) = p.labor_sch_type
and	pal3.lookup_type (+) = 'PROJECT SCHEDULE TYPE'
and	pal4.lookup_code (+) = p.non_labor_sch_type
and	pal4.lookup_type (+) = 'PROJECT SCHEDULE TYPE'
and	pal1.lookup_code (+) = sc1.schedule_type
and	pal1.lookup_type (+) = 'SCHEDULE TYPE'
and	pal2.lookup_code (+) = sc2.schedule_type
and	pal2.lookup_type (+) = 'SCHEDULE TYPE'
and 	p.emp_bill_rate_schedule_id =  sc1.bill_rate_sch_id (+)  
and 	p.job_bill_rate_schedule_id  =  sc3.bill_rate_sch_id (+)  
and 	p.non_labor_std_bill_rate_schdl = sc2.std_bill_rate_schedule (+)
and     dist.distribution_rule (+) = p.distribution_rule
and     ifl.invoice_format_id (+) = p.labor_invoice_format_id
and     ife.invoice_format_id (+) = p.non_labor_invoice_format_id
and     ifr.invoice_format_id (+) = p.retention_invoice_format_id
and     ifb.invoice_format_id (+) = p.retn_billing_inv_format_id
and     per2.organization_id (+) = p.job_bill_rate_schedule_id
and     per2tl.organization_id (+) = per2.organization_id
and     decode(per2tl.organization_id,null,'1',per2tl.language) =
          decode(per2tl.organization_id,null,'1',userenv('lang'))
and     per3.organization_id (+) = p.non_labor_bill_rate_org_id
and     per3tl.organization_id (+) = per3.organization_id
and     decode(per3tl.organization_id,null,'1',per3tl.language) =
          decode(per3tl.organization_id,null,'1',userenv('lang'))
and :ptcc = 'CONTRACT' )
 and (p.project_id=:project_id_1)