PA Federal SF 1443

Description

Application: Projects
Source: MGT: Federal SF 1443
Short Name: PAXFBPPS_XML
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

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)))

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