ECC Receivables, Billing Process, SQL3
Description
- Categories
- Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: ar-billproc
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Dataset Key: ar-billproc
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
SQL 20 lines
select x.* from ( select * from (SELECT ERROR_COUNT , TYPE , MESSAGE , ORG_ID , OPERATING_UNIT , LEDGER_CURRENCY , LEDGER , ECC_SPEC_ID , RECORD_TYPE , LANGUAGE FROM ar_ecc_interface_error_v where language in ('US')) PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameters 1
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Operating Unit | LOV |
|