ECC Quality Management, Sales Transaction

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Sales Transaction Data Set
Dataset Key: cn-trx
Query Procedure: CN_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: CN_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
select
x.*
from
(
SELECT * FROM CN_ECC_TRX_V  PIVOT
										(max(API_OPERATING_UNIT) 		as API_OPERATING_UNIT,
										 max(OPERATING_UNIT)     		as OPERATING_UNIT,
										 max(PMT_OPERATING_UNIT)     	as PMT_OPERATING_UNIT,
										 max(PAYSHEET_OPERATING_UNIT)   as PAYSHEET_OPERATING_UNIT,
										 max(PAYRUN_OPERATING_UNIT)     as PAYRUN_OPERATING_UNIT,
										 max(API_ROLE)    				as API_ROLE,
										 max(ROLE)     					as ROLE,
										 max(PAYSHEET_ROLE)     		as PAYSHEET_ROLE,
										 max(PMT_ROLE)     				as PMT_ROLE,
										 max(API_COMP_GROUP)     		as API_COMP_GROUP,
										 max(COMPENSATION_GROUP)     	as COMPENSATION_GROUP,
										 max(CREDIT_RECEIVER)			as CREDIT_RECEIVER
										 for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit (api)
x.api_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV
Operating Unit (comm)
x.comm_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV
Operating Unit (payrun)
x.payrun_org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV