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_DELINQUENCIES_UWQ_V

Object Details

Object Name:	IEX_DELINQUENCIES_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	Mandatory
IEU_OBJECT_FUNCTION	VARCHAR2	(30)
IEU_OBJECT_PARAMETERS	VARCHAR2	(2082)
IEU_MEDIA_TYPE_UUID	CHAR	(0)
IEU_PARAM_PK_COL	CHAR	(14)
IEU_PARAM_PK_VALUE	VARCHAR2	(40)
DELINQUENCY_ID	NUMBER		Yes
RESOURCE_ID	NUMBER
CUSTOMER_ID	NUMBER
RESOURCE_TYPE	CHAR	(11)
PARTY_NAME	VARCHAR2	(360)	Yes
FIRST_NAME	VARCHAR2	(150)
LAST_NAME	VARCHAR2	(150)
PARTY_TYPE	VARCHAR2	(30)	Yes
CUST_ACCOUNT_ID	NUMBER
ACCOUNT_NUMBER	VARCHAR2	(30)
SITE_USE_ID	NUMBER
PAYMENT_SCHEDULE_ID	NUMBER
AGING_BUCKET_LINE_ID	NUMBER
BUCKET_NAME	CHAR	(0)
TRANSACTION_ID	NUMBER
AMOUNT_DUE_ORIGINAL	NUMBER
AMOUNT_DUE_REMAINING	NUMBER
TRANSACTION_NUMBER	VARCHAR2	(30)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
DUE_DATE	DATE
GL_DATE	DATE
TERM_ID	NUMBER	(15)
TERMS_SEQUENCE_NUMBER	NUMBER	(15)
AUTOASSIGN_YN	VARCHAR2	(10)
STATUS	VARCHAR2	(30)
CAMPAIGN_SCHED_ID	NUMBER
SOURCE_CODE	VARCHAR2	(30)
ORG_ID	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_BYNAME	VARCHAR2	(360)
UWQ_STATUS	VARCHAR2	(30)
UWQ_ACTIVE_DATE	DATE
UWQ_COMPLETE_DATE	DATE
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes

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
,      DELINQUENCY_ID
,      RESOURCE_ID
,      CUSTOMER_ID
,      RESOURCE_TYPE
,      PARTY_NAME
,      FIRST_NAME
,      LAST_NAME
,      PARTY_TYPE
,      CUST_ACCOUNT_ID
,      ACCOUNT_NUMBER
,      SITE_USE_ID
,      PAYMENT_SCHEDULE_ID
,      AGING_BUCKET_LINE_ID
,      BUCKET_NAME
,      TRANSACTION_ID
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      TRANSACTION_NUMBER
,      INVOICE_CURRENCY_CODE
,      DUE_DATE
,      GL_DATE
,      TERM_ID
,      TERMS_SEQUENCE_NUMBER
,      AUTOASSIGN_YN
,      STATUS
,      CAMPAIGN_SCHED_ID
,      SOURCE_CODE
,      ORG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_BYNAME
,      UWQ_STATUS
,      UWQ_ACTIVE_DATE
,      UWQ_COMPLETE_DATE
,      OPERATING_UNIT_NAME
FROM APPS.IEX_DELINQUENCIES_UWQ_V;

Dependencies

[top of page]

APPS.IEX_DELINQUENCIES_UWQ_V references the following:

APPS: AMS_SOURCE_CODES; AR_PAYMENT_SCHEDULES_ALL; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; HZ_PARTIES; IEX_DELINQUENCIES; JTF_OBJECTS_B; JTF_RS_RESOURCE_EXTNS

APPS.IEX_DELINQUENCIES_UWQ_V is not referenced by any database object