PA Project Configuration
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Project Configuration
Application: Projects
Source: AUD: Project Configuration (XML)
Short Name: PAXPRCON_XML
DB package: PA_PAXPRCON_XMLP_PKG
Description: Project Configuration
Application: Projects
Source: AUD: Project Configuration (XML)
Short Name: PAXPRCON_XML
DB package: PA_PAXPRCON_XMLP_PKG
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) |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Project Number |
|
LOV Oracle |