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
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |