ECC Genealogy and Trace, Purchase Orders

Description

Categories
Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: gnt-potransactions
Query Procedure: WIP_ECC_GNT_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: PO_PCC_DATASECURITY_PKG_PUB.GetFilterAttributeValuesPO

SQL 214 lines

Parameters 1

ParameterTypeList of values SQL
Operating UnitLOV
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)