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_TRX_SUMMARY_V

Object Details

Object Name:	IEX_TRX_SUMMARY_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
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes
TRX_NUMBER	VARCHAR2	(20)	Yes
TERMS_SEQUENCE_NUMBER	NUMBER	(15)
PURCHASE_ORDER	VARCHAR2	(50)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
DUE_DATE	DATE		Yes
TRX_DATE	DATE		Yes
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes
AMOUNT_DUE_ORIGINAL	NUMBER		Yes
AMOUNT_DUE_REMAINING	NUMBER		Yes
ACCTD_AMOUNT_DUE_REMAINING	NUMBER		Yes
CUST_TRX_STATUS_CODE	VARCHAR2	(30)	Yes
CUST_TRX_STATUS_NAME	VARCHAR2	(80)	Yes
CUST_TRX_CLASS_CODE	VARCHAR2	(20)	Yes
CUST_TRX_TYPE_ID	NUMBER	(15)
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_TRX_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
DOC_SEQUENCE_VALUE	NUMBER	(15)
DELINQUENCY_ID	NUMBER
DELINQUENCY_STATUS	VARCHAR2	(30)
DEL_STATUS_DSP	VARCHAR2	(80)
DAYS_PAST_DUE	NUMBER
SALES_ORDER	CHAR	(0)
GL_DATE	DATE		Yes
COMMENTS	VARCHAR2	(1760)
TERM_ID	NUMBER	(15)
PRIMARY_SALESREP_ID	NUMBER	(15)
PRIMARY_SALESREP_NAME	VARCHAR2	(4000)
BILL_TO_CUSTOMER_ID	NUMBER	(15)
PARTY_ID	NUMBER	(15)	Yes
TRX_CREATION_DATE	DATE		Yes
CONS_INV_ID	NUMBER	(15)
CONS_BILLING_NUMBER	VARCHAR2	(30)
CUSTOMER_SITE_USE_ID	NUMBER	(15)
CUST_TRX_CLASS_NAME	VARCHAR2	(80)	Yes
DISPUTE_DATE	DATE
AMOUNT_IN_DISPUTE	NUMBER
PROMISED_FLAG	CHAR	(0)
PAID_FLAG	CHAR	(0)
TERM_NAME	VARCHAR2	(15)

Query Text

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


SELECT PAYMENT_SCHEDULE_ID
,      TRX_NUMBER
,      TERMS_SEQUENCE_NUMBER
,      PURCHASE_ORDER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DUE_DATE
,      TRX_DATE
,      INVOICE_CURRENCY_CODE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      ACCTD_AMOUNT_DUE_REMAINING
,      CUST_TRX_STATUS_CODE
,      CUST_TRX_STATUS_NAME
,      CUST_TRX_CLASS_CODE
,      CUST_TRX_TYPE_ID
,      CUSTOMER_ID
,      CUSTOMER_TRX_ID
,      ORG_ID
,      ACCOUNT_NUMBER
,      DOC_SEQUENCE_VALUE
,      DELINQUENCY_ID
,      DELINQUENCY_STATUS
,      DEL_STATUS_DSP
,      DAYS_PAST_DUE
,      SALES_ORDER
,      GL_DATE
,      COMMENTS
,      TERM_ID
,      PRIMARY_SALESREP_ID
,      PRIMARY_SALESREP_NAME
,      BILL_TO_CUSTOMER_ID
,      PARTY_ID
,      TRX_CREATION_DATE
,      CONS_INV_ID
,      CONS_BILLING_NUMBER
,      CUSTOMER_SITE_USE_ID
,      CUST_TRX_CLASS_NAME
,      DISPUTE_DATE
,      AMOUNT_IN_DISPUTE
,      PROMISED_FLAG
,      PAID_FLAG
,      TERM_NAME
FROM APPS.IEX_TRX_SUMMARY_V;

Dependencies

[top of page]

APPS.IEX_TRX_SUMMARY_V references the following:

APPS: ARPT_SQL_FUNC_UTIL - show dependent code; AR_CONS_INV; AR_LOOKUPS; AR_PAYMENT_SCHEDULES; FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; IEX_DELINQUENCIES; IEX_LOOKUPS_V; RA_CUSTOMER_TRX; RA_TERMS_VL

APPS.IEX_TRX_SUMMARY_V is not referenced by any database object