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

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
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
LOV