PA Pay When Paid Release Audit

Description
Categories: BI Publisher, Financials
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
Sort By
 
LOV Oracle
To Customer Receipt Date
 
Date
From Customer Receipt Date
 
Date
Customer Number
 
LOV Oracle
Customer Name
 
LOV Oracle
From Project Number
 
From Project Number
 
Project Number
 
LOV Oracle
Project Type
 
LOV Oracle
Mode
 
LOV Oracle
REQUEST_ID
 
Number