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_LS_TRX_BSC_V

Object Details

Object Name:	IEX_LS_TRX_BSC_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	Comments
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Identifies the payment schedule
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction number
TERMS_SEQUENCE_NUMBER	NUMBER	(15)		The sequence number given to each installment for multiple payment terms
PURCHASE_ORDER	VARCHAR2	(50)		Purchase order
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DUE_DATE	DATE		Yes	Due date of this installment
TRX_DATE	DATE		Yes	Invoice date
INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes	Lookup code for the currency of the invoice
AMOUNT_DUE_ORIGINAL	NUMBER		Yes	The original amount due
AMOUNT_DUE_REMAINING	NUMBER		Yes	The current amount due remaining
ACCTD_AMOUNT_DUE_REMAINING	NUMBER		Yes	Open amount of transaction in functional currency
CUST_TRX_STATUS_CODE	VARCHAR2	(30)	Yes	Lookup code for the status of the item
CUST_TRX_STATUS_NAME	VARCHAR2	(80)	Yes
CUST_TRX_CLASS_CODE	VARCHAR2	(20)	Yes
CUST_TRX_CLASS_NAME	VARCHAR2	(80)	Yes
CUST_TRX_TYPE_ID	NUMBER	(15)
CUST_TRX_TYPE_NAME	VARCHAR2	(20)
PARTY_ID	NUMBER	(15)	Yes
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_SITE_USE_ID	NUMBER	(15)
CUSTOMER_TRX_ID	NUMBER	(15)
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
EXCHANGE_DATE	DATE
EXCHANGE_RATE	NUMBER
ORG_ID	NUMBER	(15)		Organization identifier
CUSTOMER_NAME	VARCHAR2	(360)	Yes
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes
CUST_TRX_LOCATION	VARCHAR2	(40)	Yes
BILL_TO_CONTACT_ID	NUMBER	(15)
BILL_TO_FIRST_NAME	VARCHAR2	(150)
BILL_TO_LAST_NAME	VARCHAR2	(150)
DOC_SEQUENCE_VALUE	NUMBER	(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_CLASS_NAME
,      CUST_TRX_TYPE_ID
,      CUST_TRX_TYPE_NAME
,      PARTY_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CUSTOMER_TRX_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      ORG_ID
,      CUSTOMER_NAME
,      ACCOUNT_NUMBER
,      CUST_TRX_LOCATION
,      BILL_TO_CONTACT_ID
,      BILL_TO_FIRST_NAME
,      BILL_TO_LAST_NAME
,      DOC_SEQUENCE_VALUE
FROM APPS.IEX_LS_TRX_BSC_V;

Dependencies

[top of page]

APPS.IEX_LS_TRX_BSC_V references the following:

APPS: AR_LOOKUPS; AR_PAYMENT_SCHEDULES; HZ_CUST_ACCOUNTS; HZ_CUST_ACCOUNT_ROLES; HZ_CUST_SITE_USES; HZ_PARTIES; HZ_RELATIONSHIPS; RA_CUSTOMER_TRX; RA_CUST_TRX_TYPES

APPS.IEX_LS_TRX_BSC_V is not referenced by any database object