ECC Receivables, Disputes

Description
Categories: Enterprise Command Center
Columns: Dispute Number, Dispute Reason Code, Dispute Requestor, Currency Code, Transaction Number, Sales Order, Account Number, Bill To Customer, Bill To Location, Collector ...
Imported from Enterprise Command Center
Dataset Key: ar-dispute
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
select
x.*
from
(
select * from (SELECT /*+ leading(cmreq_v.temp.process_t) full(cmreq_v.temp.process_t) */ DISPUTE_NUMBER
, DISPUTE_REASON
, DISPUTE_REASON_CODE
, DISPUTE_STATUS
, DISPUTE_REQUESTOR
, CURRENCY
, CURRENCY_CODE
, TRANSACTION_NUMBER
, SALESPERSON
, SALES_ORDER
, OPERATING_UNIT
, ACCOUNT_NUMBER
, BILL_TO_CUSTOMER
, BILL_TO_LOCATION
, COLLECTOR
, PROFILE_CLASS
, DISPUTE_DATE
, TRANSACTION_DATE
, DUE_DATE
, ECC_SPEC_ID
, DISPUTE_STATUS_CODE
, DISPUTE_AMOUNT
, TRANSACTION_CLASS
, TRANSACTION_CLASS_CODE
, TRANSACTION_ID
, ECC_LAST_UPDATE_DATE
, ORG_ID
, STATUS
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, TRANSACTION_AMOUNT
, BILL_TO_CONTACT
, SHIP_TO_CUSTOMER
, SHIP_TO_LOCATION
, PURCHASE_ORDER_NUMBER
, DUE_AMOUNT
, PURCHASE_ORDER_DATE
, RECORD_TYPE
, LANGUAGE
FROM ari_ecc_cmreq_v cmreq_v where cmreq_v.language in ('US')) PIVOT(max(SALESPERSON) as SALESPERSON, max(OPERATING_UNIT) as OPERATING_UNIT, max(CURRENCY) as CURRENCY, max(DISPUTE_REASON) as DISPUTE_REASON,
   max(DISPUTE_STATUS) as DISPUTE_STATUS,max(TRANSACTION_CLASS) as TRANSACTION_CLASS
   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