PA Project Expenditure Items with WIP and INV Detail

Description

Categories
Enginatics, R12 only
Repository
GitHub
Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and inventory item information.

SQL 89 lines

Parameters 9

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
ProjectLOV
ppa.segment1=:project_number
TaskLOV
pt.task_number=:task_number
Date FromDate
peia.expenditure_item_date>=:date_from
Date ToDateTime
peia.expenditure_item_date<:date_to+1
Expenditure TypeLOV
peia.expenditure_type=:expenditure_type
Expenditure Type ClassLOV
peia.system_linkage_function=:expenditure_type_class
JobLOV
we.wip_entity_name=:job
EmployeeLOV
ppx.full_name=:employee