PA Invoice Review

Description

Categories
Enginatics
Repository
GitHub
Project draft invoices with line details showing invoice amounts, approval and release status, customer, GL date, and expenditure type breakdown.

SQL 49 lines

Parameters 5

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
ProjectLOV
ppa.segment1=:project_number
Invoice Date FromDate
pdia.invoice_date>=:invoice_date_from
Invoice Date ToDate
pdia.invoice_date<:invoice_date_to+1
ReleasedLOV
decode(pdia.released_date,null,'N','Y')=:released