PA Federal SF 1443

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: MGT: Federal SF 1443
Short Name: PAXFBPPS_XML
DB package:
Run PA Federal SF 1443 and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT CONTRACT_NUMBER C_4A,--C_4A
       DELIVERY_ORDER C_4B, --4 B
       CONTRACT_VALUE C_5,  --5
       PROGRESS_PAYMENT_RATE C_6A,--6 A
       LIQUIDATION_RATE C_6B, --6B
       COST_ELIGIBLE_FOR_PP C_11, --11
       COST_ELIGIBLE_FOR_PP C_12A, --12 A
        GREATEST(((CONTRACT_VALUE/(1+(EAC_RATE/100))) - COST_ELIGIBLE_FOR_PP),0) C_12B,--12B
       (COST_ELIGIBLE_FOR_PP + (GREATEST(CONTRACT_VALUE/(1+(EAC_RATE/100)) - COST_ELIGIBLE_FOR_PP,0))) C_12C,--12C
       (COST_ELIGIBLE_FOR_PP * (PROGRESS_PAYMENT_RATE/100)) C_13,
       SUBCONTRACTOR_PROGRESS_AMT C_14A,
       SUBCONTRACTOR_LIQ_AMT  C_14B,
       (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT) C_14C,
       (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT) C_14E,
       ((COST_ELIGIBLE_FOR_PP * (PROGRESS_PAYMENT_RATE/100))+ (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)) C_15,
       (CONTRACT_VALUE * (LIQUIDATION_RATE/100)) C_16,
       LEAST(((COST_ELIGIBLE_FOR_PP * (PROGRESS_PAYMENT_RATE/100))+ (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),(CONTRACT_VALUE * (LIQUIDATION_RATE/100)))C_17,
       PREVIOUS_PROGRESS_PAYMENT C_18,
       SECII_ELIGIBLE_PP_AMOUNT C_19,
       SECIII_COST_INCLUDED C_20A,
       (COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED) C_20B,
       ((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) C_20C,
       (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT) C_20D,
       (((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)) C_20E,
       SECIII_SHIPMENT_INVOICED C_21A,
       (CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) C_21B,
       ((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)) C_21C,
       ((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)) C_21E,
       LEAST((((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) 
       + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100))) C_22,
       SECIII_LIQ_AMOUNT C_23,
       (PREVIOUS_PROGRESS_PAYMENT-SECIII_LIQ_AMOUNT) C_24 ,
       (LEAST((((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) 
       + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)))-(PREVIOUS_PROGRESS_PAYMENT-SECIII_LIQ_AMOUNT)) C_25,
       LEAST((LEAST((((COST_ELIGIBLE_FOR_PP-SECIII_COST_INCLUDED)* (PROGRESS_PAYMENT_RATE/100)) 
       + (SUBCONTRACTOR_PROGRESS_AMT-SUBCONTRACTOR_LIQ_AMT)),((CONTRACT_VALUE - SECIII_SHIPMENT_INVOICED) * (LIQUIDATION_RATE/100)))-(PREVIOUS_PROGRESS_PAYMENT-SECIII_LIQ_AMOUNT)),SECII_ELIGIBLE_PP_AMOUNT) C_26
FROM  PA_SF1443_REPORT_DETAILS SFRD,
      PA_DRAFT_CONSOLIDATED_INV_ALL DI
WHERE DI.DRAFT_INVOICE_NUM=SFRD.DRAFT_INVOICE_NUM
AND   DI.BILL_GROUP_ID=SFRD.BILL_GROUP_ID
AND   (DI.RA_INVOICE_NUMBER= :ARINVNUM OR (DI.RA_INVOICE_NUMBER IS NULL AND (DI.DRAFT_INVOICE_NUM= :CONSINVNUM AND DI.BILL_GROUP_ID=:BILL_GROUP)))
Parameter Name SQL text Validation
AR Invoice Number 
 
 Char
Download
Related Blitz Reports
ECC Receivables, Outstanding Receivables (14) ECC Receivables, Outstanding Receivables (2) ECC Receivables, Outstanding Receivables (1) PA Federal SF 1035 ECC Receivables, Payment History, SQL1 PA Federal SF 1034 ECC Receivables, Outstanding Receivables (16) ECC Receivables, Outstanding Receivables (7) ECC Receivables, Billing Process, SQL1
Blitz Report™

Blitz Report™ provides multiple benefits: