ECC Payables, Holds
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: ap-hold
Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AP_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Dataset Key: ap-hold
Query Procedure: AP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AP_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 ECC_SPEC_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, RECORD_TYPE, INVOICE_ID, INVOICE_NUMBER, HOLD_DATE, HOLD_NAME_CODE, HOLD_TYPE_CODE, USER_RELEASE_CODE, USER_RELEASEABLE_FLAG, HOLD_NAME, HOLD_TYPE, DESCRIPTION, ORG_ID, OPERATING_UNIT, INVOICE_TYPE, LEGAL_ENTITY, SUPPLIER_TYPE,SUPPLIER_TYPE_CODE, SUPPLIER_NAME , SUPPLIER_NUMBER , SITE_CODE, INVOICE_DATE, GL_DATE, INV_CURRENCY, INV_CURRENCY_CODE, INVOICE_AMOUNT, UNPAID_AMOUNT, LEDGER, GL_CURRENCY,GL_CURRENCY_CODE, PO_NUMBERS, VOUCHER_NUM, SOURCE, LANGUAGE from AP_ECC_HOLD_V HOLD where exists (select 1 from AP_ECC_TRX_PROCESS TEMP WHERE TEMP.INVOICE_ID = HOLD.INVOICE_ID) and language in ('US')) PIVOT (max(OPERATING_UNIT) as OPERATING_UNIT, max(USER_RELEASEABLE_FLAG) as USER_RELEASEABLE_FLAG, max(HOLD_NAME) as HOLD_NAME, max(HOLD_TYPE) as HOLD_TYPE, max(INVOICE_TYPE) as INVOICE_TYPE, max(SUPPLIER_TYPE) as SUPPLIER_TYPE,max(INV_CURRENCY) as INV_CURRENCY, max(GL_CURRENCY) as GL_CURRENCY for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV |