ECC Quality Management, Sales Transaction

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Ecc Last Update Date, Api Processed Date, Api Employee Number, Api Salesrep, Api Salesrep Id, Api Org Id, Api Transaction Type, Api Transaction Amount, Api Revenue Type ...
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