PA Compile All Burden Schedule Revisions

➜ Back to Library
Description
Categories: BI Publisher
Columns: Ind Rate Sch Name1, Ind Rate Sch Revision1, Meaning1 ...
Application: Projects
Source: PRC: Compile All Burden Schedule Revisions (XML)
Short Name: PAXCCARS_XML
DB package: PA_PAXCCARS_XMLP_PKG 
select irs.ind_rate_sch_name IND_RATE_SCH_NAME1, 
		 irsr.ind_rate_sch_revision IND_RATE_SCH_REVISION1,
           lu.meaning MEANING1
from pa_ind_rate_sch_revisions irsr, 
         pa_ind_rate_schedules irs,
         pa_lookups lu
where irsr.compiled_flag = 'Y'
and     irsr.request_id = :P_CONC_REQUEST_ID
and     irsr.ind_rate_sch_id = irs.ind_rate_sch_id
and     irsr.ind_rate_sch_revision_type = lu.lookup_code
and     lu.lookup_type = 'IND RATE SCHEDULE REV TYPE'
Parameter Name SQL text Validation
Debug Mode 
 
Download
Related Blitz Reports
PA Project Types PA Project Configuration ECC Projects, Projects Costing: PSI Summary, SQL1 ECC Projects, Projects Costing: Transactions, SQL1 PON Solicitation data template ECC Project Procurement, Procurement Plan, SQL1 ECC Procurement, Indirect Procurement, SQL2 ECC Procurement, Indirect Procurement, SQL6 ECC Procurement, Indirect Procurement, SQL5
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: