eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IEX_DISPUTES_V

Object Details

Object Name:	IEX_DISPUTES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
DISPUTE_DATE	DATE
CREATION_DATE	DATE		Yes
CM_REQUEST_ID	NUMBER	(15)	Yes
INVOICE_NUMBER	VARCHAR2	(20)	Yes
CUSTOMER_TRX_ID	NUMBER	(15)	Yes
DISPUTE_STATUS	VARCHAR2	(20)
DISPUTE_STATUS_MEANING	VARCHAR2	(4000)
DISPUTE_REASON	VARCHAR2	(30)
DISPUTE_REASON_MEANING	VARCHAR2	(4000)
DISPUTE_SECTION	VARCHAR2	(25)
DISPUTE_SECTION_MEANING	VARCHAR2	(4000)
DISPUTE_AMOUNT	NUMBER
ACCOUNT_ID	NUMBER	(15)
PARTY_CUST_ID	NUMBER	(15)	Yes
DELINQUENCY_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CUSTOMER_SITE_USE_ID	NUMBER	(15)
LOCATION	VARCHAR2	(0)
PARTY_SITE_NUMBER	NUMBER
ADDRESS	VARCHAR2	(0)
CONS_BILLING_NUMBER	NUMBER
ORG_ID	NUMBER
OPERATING_UNIT	VARCHAR2	(0)
PARTY_NAME	VARCHAR2	(0)
ACCOUNT_NUMBER	NUMBER	(15)
TRX_CREATION_DATE	DATE		Yes
TRX_CLASS	VARCHAR2	(4000)
PURCHASE_ORDER	VARCHAR2	(50)
SALES_ORDER	NUMBER
COMMENTS	VARCHAR2	(1760)
INTERNAL_COMMENT	VARCHAR2	(1760)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      DISPUTE_DATE
,      CREATION_DATE
,      CM_REQUEST_ID
,      INVOICE_NUMBER
,      CUSTOMER_TRX_ID
,      DISPUTE_STATUS
,      DISPUTE_STATUS_MEANING
,      DISPUTE_REASON
,      DISPUTE_REASON_MEANING
,      DISPUTE_SECTION
,      DISPUTE_SECTION_MEANING
,      DISPUTE_AMOUNT
,      ACCOUNT_ID
,      PARTY_CUST_ID
,      DELINQUENCY_ID
,      CURRENCY_CODE
,      CUSTOMER_SITE_USE_ID
,      LOCATION
,      PARTY_SITE_NUMBER
,      ADDRESS
,      CONS_BILLING_NUMBER
,      ORG_ID
,      OPERATING_UNIT
,      PARTY_NAME
,      ACCOUNT_NUMBER
,      TRX_CREATION_DATE
,      TRX_CLASS
,      PURCHASE_ORDER
,      SALES_ORDER
,      COMMENTS
,      INTERNAL_COMMENT
FROM APPS.IEX_DISPUTES_V;

Dependencies

[top of page]

APPS.IEX_DISPUTES_V references the following:

APPS: ARPT_SQL_FUNC_UTIL - show dependent code; HZ_CUST_ACCOUNTS; IEX_DISPUTES; IEX_UTILITIES - show dependent code; RA_CM_REQUESTS; RA_CUSTOMER_TRX; RA_CUST_TRX_TYPES

APPS.IEX_DISPUTES_V is not referenced by any database object