PA Pay When Paid Release Audit

Description
Categories: BI Publisher
Columns: Project Number, Name, Invoice Num, Contractor, Contract, Invoice Currency Code, Invoice Amount, Exception ...
Application: Projects
Source: AUD: Pay When Paid Release Audit
Short Name: PAPWPRIREP
DB package: PA_PAPWPRIREP_XMLP_PKG
		SELECT DISTINCT
				prj.segment1   project_number ,
				prj.name                ,
				ap.invoice_num          ,
				pov.vendor_name      contractor   ,
				poh.segment1  contract   ,
				ap.invoice_currency_code ,
				ap.invoice_amount       ,
				rep.exception   
		FROM    
				AP_INVOICES ap        ,
				AP_INVOICE_LINES apl      ,
				po_vendors pov            ,
				PO_headers poh        ,
				PA_PWP_RELEASE_REPORT rep ,
				pa_projects prj 
		WHERE   
				prj.project_id   = rep.project_id
				AND ap.invoice_id    = rep.ap_invoice_id
				AND ap.invoice_id    = apl.invoice_id
				AND pov.vendor_id    = ap.vendor_id
				AND apl.po_header_id = poh.po_header_id(+)   
				AND rep.request_id   = :P_REQUEST_ID 
        AND  rep.EXCEPTION   IS  NOT NULL
Parameter Name SQL text Validation
REQUEST_ID
 
Number
Mode
 
LOV Oracle
Project Type
 
LOV Oracle
Project Number
 
LOV Oracle
From Project Number
 
From Project Number
 
Customer Name
 
LOV Oracle
Customer Number
 
LOV Oracle
From Customer Receipt Date
 
Date
To Customer Receipt Date
 
Date
Sort By
 
LOV Oracle