VIEW: APPS.IEX_DISPUTES_V

Source

View Text - Preformatted

SELECT dis.rowid row_id, nvl(req.dispute_date, req.creation_date) dispute_date, req.creation_date creation_date, req.request_id cm_request_id, trx.trx_number invoice_number, trx.customer_trx_id customer_trx_id, req.status dispute_status, arpt_sql_func_util.get_lookup_meaning('CREDIT_MEMO_REQUEST_STATUS', req.status) dispute_status_meaning, req.cm_reason_code dispute_reason, arpt_sql_func_util.get_lookup_meaning('CREDIT_MEMO_REASON', req.cm_reason_code) dispute_reason_meaning, dis.dispute_section dispute_section, iex_utilities.get_lookup_meaning('IEX_DISPUTED_SECTION', dis.dispute_section) dispute_section_meaning, decode(req.total_amount, 0, req.line_amount, req.total_amount) dispute_amount, trx.bill_to_customer_id account_id, hca.party_id party_cust_id, to_number(NULL) delinquency_id, trx.invoice_currency_code currency_code, trx.bill_to_site_use_id customer_site_use_id, to_char(NULL) location, to_number(NULL) party_site_number, to_char(NULL) address, to_number(NULL) cons_billing_number, to_number(NULL) org_id, to_char(NULL) operating_unit, to_char(NULL) party_name, trx.bill_to_customer_id account_number, trx.creation_date trx_creation_date, arpt_sql_func_util.get_lookup_meaning('INV/CM', typ.type) trx_class, trx.purchase_order purchase_order, to_number(NULL) sales_order, req.comments comments, req.internal_comment internal_comment FROM iex_disputes dis, ra_customer_trx trx, ra_cm_requests req, hz_cust_accounts hca, ra_cust_trx_types typ WHERE req.customer_trx_id = trx.customer_trx_id AND trx.bill_to_customer_id = hca.cust_account_id AND trx.bill_to_customer_id = hca.cust_account_id AND req.request_id = dis.cm_request_id(+) AND typ.cust_trx_type_id = trx.cust_trx_type_id AND typ.org_id=req.org_id

View Text - HTML Formatted

SELECT DIS.ROWID ROW_ID
, NVL(REQ.DISPUTE_DATE
, REQ.CREATION_DATE) DISPUTE_DATE
, REQ.CREATION_DATE CREATION_DATE
, REQ.REQUEST_ID CM_REQUEST_ID
, TRX.TRX_NUMBER INVOICE_NUMBER
, TRX.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, REQ.STATUS DISPUTE_STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CREDIT_MEMO_REQUEST_STATUS'
, REQ.STATUS) DISPUTE_STATUS_MEANING
, REQ.CM_REASON_CODE DISPUTE_REASON
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CREDIT_MEMO_REASON'
, REQ.CM_REASON_CODE) DISPUTE_REASON_MEANING
, DIS.DISPUTE_SECTION DISPUTE_SECTION
, IEX_UTILITIES.GET_LOOKUP_MEANING('IEX_DISPUTED_SECTION'
, DIS.DISPUTE_SECTION) DISPUTE_SECTION_MEANING
, DECODE(REQ.TOTAL_AMOUNT
, 0
, REQ.LINE_AMOUNT
, REQ.TOTAL_AMOUNT) DISPUTE_AMOUNT
, TRX.BILL_TO_CUSTOMER_ID ACCOUNT_ID
, HCA.PARTY_ID PARTY_CUST_ID
, TO_NUMBER(NULL) DELINQUENCY_ID
, TRX.INVOICE_CURRENCY_CODE CURRENCY_CODE
, TRX.BILL_TO_SITE_USE_ID CUSTOMER_SITE_USE_ID
, TO_CHAR(NULL) LOCATION
, TO_NUMBER(NULL) PARTY_SITE_NUMBER
, TO_CHAR(NULL) ADDRESS
, TO_NUMBER(NULL) CONS_BILLING_NUMBER
, TO_NUMBER(NULL) ORG_ID
, TO_CHAR(NULL) OPERATING_UNIT
, TO_CHAR(NULL) PARTY_NAME
, TRX.BILL_TO_CUSTOMER_ID ACCOUNT_NUMBER
, TRX.CREATION_DATE TRX_CREATION_DATE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('INV/CM'
, TYP.TYPE) TRX_CLASS
, TRX.PURCHASE_ORDER PURCHASE_ORDER
, TO_NUMBER(NULL) SALES_ORDER
, REQ.COMMENTS COMMENTS
, REQ.INTERNAL_COMMENT INTERNAL_COMMENT
FROM IEX_DISPUTES DIS
, RA_CUSTOMER_TRX TRX
, RA_CM_REQUESTS REQ
, HZ_CUST_ACCOUNTS HCA
, RA_CUST_TRX_TYPES TYP
WHERE REQ.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND TRX.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND TRX.BILL_TO_CUSTOMER_ID = HCA.CUST_ACCOUNT_ID
AND REQ.REQUEST_ID = DIS.CM_REQUEST_ID(+)
AND TYP.CUST_TRX_TYPE_ID = TRX.CUST_TRX_TYPE_ID
AND TYP.ORG_ID=REQ.ORG_ID