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_PROMISES_UWQ_V

Object Details

Object Name:	IEX_PROMISES_UWQ_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
IEU_OBJECT_FUNCTION	VARCHAR2	(30)
IEU_OBJECT_PARAMETERS	VARCHAR2	(2082)
IEU_MEDIA_TYPE_UUID	CHAR	(0)
IEU_PARAM_PK_COL	CHAR	(17)
IEU_PARAM_PK_VALUE	VARCHAR2	(40)
RESOURCE_ID	NUMBER
RESOURCE_TYPE	VARCHAR2	(13)
CUST_ACCOUNT_ID	NUMBER
ACCOUNT_NUMBER	VARCHAR2	(30)
DELINQUENCY_ID	NUMBER
PAYMENT_SCHEDULE_ID	NUMBER
CUSTOMER_TRX_ID	NUMBER
TRX_NUMBER	VARCHAR2	(30)
TRX_DATE	DATE
TERMS_SEQUENCE_NUMBER	NUMBER
DUE_DATE	DATE
PROMISE_DATE	DATE
PROMISE_AMOUNT	NUMBER
PROMISE_PAYMENT_METHOD	VARCHAR2	(30)
PAYMENT_METHOD	VARCHAR2	(80)
AMOUNT_DUE_REMAINING	NUMBER
STATUS	VARCHAR2	(30)
ACCOUNT	VARCHAR2	(240)
PROMISE_ITEM_NUMBER	VARCHAR2	(240)
CURRENCY_CODE	VARCHAR2	(240)
SOURCE_CODE	VARCHAR2	(30)
PARTY_NAME	VARCHAR2	(360)
FIRST_NAME	VARCHAR2	(150)
LAST_NAME	VARCHAR2	(150)
PARTY_ID	NUMBER	(15)
CREATION_DATE	DATE		Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BYNAME	VARCHAR2	(360)
UWQ_STATUS	VARCHAR2	(240)
UWQ_ACTIVE_DATE	DATE
UWQ_COMPLETE_DATE	DATE
ORG_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)
TASK_NAME	VARCHAR2	(80)
TASK_NUMBER	VARCHAR2	(30)
TASK_STATUS	VARCHAR2	(30)

Query Text

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


SELECT IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      RESOURCE_ID
,      RESOURCE_TYPE
,      CUST_ACCOUNT_ID
,      ACCOUNT_NUMBER
,      DELINQUENCY_ID
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_DATE
,      TERMS_SEQUENCE_NUMBER
,      DUE_DATE
,      PROMISE_DATE
,      PROMISE_AMOUNT
,      PROMISE_PAYMENT_METHOD
,      PAYMENT_METHOD
,      AMOUNT_DUE_REMAINING
,      STATUS
,      ACCOUNT
,      PROMISE_ITEM_NUMBER
,      CURRENCY_CODE
,      SOURCE_CODE
,      PARTY_NAME
,      FIRST_NAME
,      LAST_NAME
,      PARTY_ID
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BYNAME
,      UWQ_STATUS
,      UWQ_ACTIVE_DATE
,      UWQ_COMPLETE_DATE
,      ORG_ID
,      OPERATING_UNIT_NAME
,      TASK_NAME
,      TASK_NUMBER
,      TASK_STATUS
FROM APPS.IEX_PROMISES_UWQ_V;

Dependencies

[top of page]

APPS.IEX_PROMISES_UWQ_V references the following:

APPS: AMS_SOURCE_CODES; AR_PAYMENT_SCHEDULES_ALL; FND_GLOBAL - show dependent code; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; HZ_PARTIES; IEX_DELINQUENCIES; IEX_LOOKUPS_V; IEX_PROMISE_DETAILS; JTF_OBJECTS_B; JTF_RS_RESOURCE_EXTNS; JTF_TASKS_VL; JTF_TASK_STATUSES_VL; OKC_K_HEADERS_B

APPS.IEX_PROMISES_UWQ_V is not referenced by any database object