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_PROMISE_TO_PAY_V

Object Details

Object Name:	IEX_LS_PROMISE_TO_PAY_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	Comments
PROMISE_DETAIL_ID	NUMBER
CUST_ACCOUNT_ID	NUMBER
ACCOUNT_NUMBER	VARCHAR2	(30)	Account Number
DELINQUENCY_ID	NUMBER
PAYMENT_SCHEDULE_ID	NUMBER
CUSTOMER_TRX_ID	NUMBER		Identifies the item itself
TRX_NUMBER	VARCHAR2	(30)	The transaction number of the item
TRX_DATE	DATE		The transaction date of the item
INSTALLMENT	NUMBER		The sequence number given to each installment for multiple payment terms
DUE_DATE	DATE		Due date of this installment
CREATION_DATE	DATE		Standard who column - date when this row was created.
PROMISE_DATE	DATE
PROMISE_AMOUNT	NUMBER
PROMISE_PAYMENT_METHOD	VARCHAR2	(30)
PROMISE_PAYMENT_METHOD_DSP	VARCHAR2	(80)	QuickCode meaning
STATUS	VARCHAR2	(30)
STATUS_DSP	VARCHAR2	(80)	QuickCode meaning
ACCOUNT	VARCHAR2	(240)
PROMISE_ITEM_NUMBER	VARCHAR2	(240)
CURRENCY_CODE	VARCHAR2	(240)
PARTY_ORG_ID	NUMBER	(15)	Party identifier
ORGANIZATION	VARCHAR2	(360)	Name of this party
PARTY_PER_ID	NUMBER	(15)	Party identifier
PERSON_FIRST_NAME	VARCHAR2	(150)	First name of the person
PERSON_LAST_NAME	VARCHAR2	(150)	Last or surname of the person

Query Text

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


SELECT PROMISE_DETAIL_ID
,      CUST_ACCOUNT_ID
,      ACCOUNT_NUMBER
,      DELINQUENCY_ID
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_DATE
,      INSTALLMENT
,      DUE_DATE
,      CREATION_DATE
,      PROMISE_DATE
,      PROMISE_AMOUNT
,      PROMISE_PAYMENT_METHOD
,      PROMISE_PAYMENT_METHOD_DSP
,      STATUS
,      STATUS_DSP
,      ACCOUNT
,      PROMISE_ITEM_NUMBER
,      CURRENCY_CODE
,      PARTY_ORG_ID
,      ORGANIZATION
,      PARTY_PER_ID
,      PERSON_FIRST_NAME
,      PERSON_LAST_NAME
FROM APPS.IEX_LS_PROMISE_TO_PAY_V;

Dependencies

[top of page]

APPS.IEX_LS_PROMISE_TO_PAY_V references the following:

APPS: AR_PAYMENT_SCHEDULES; FND_LOOKUP_VALUES_VL; HZ_CUST_ACCOUNTS; HZ_PARTIES; IEX_DELINQUENCIES; IEX_PROMISE_DETAILS

APPS.IEX_LS_PROMISE_TO_PAY_V is not referenced by any database object