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_DUNNING_UWQ_V

Object Details

Object Name:	IEX_DUNNING_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	(10)
IEU_PARAM_PK_VALUE	VARCHAR2	(40)
RESOURCE_ID	NUMBER
CUSTOMER_ID	NUMBER
PARTY_NAME	VARCHAR2	(360)	Yes
FIRST_NAME	VARCHAR2	(150)
LAST_NAME	VARCHAR2	(150)
PARTY_TYPE	VARCHAR2	(30)	Yes
ACCOUNT_NUMBER	VARCHAR2	(30)
RESOURCE_TYPE	VARCHAR2	(13)
DUN_DUNNING_ID	NUMBER		Yes
DUN_TEMPLATE_ID	NUMBER
DUN_DELINQUENCY_ID	NUMBER
DATE_TIME	DATE		Yes
STATUS	VARCHAR2	(240)
SOURCE_CODE_ID	NUMBER
DUN_LAST_UPDATE_DATE	DATE		Yes
DUN_CALLBACK_DATE	DATE
AGING_BUCKET	NUMBER
BUCKET_NAME	VARCHAR2	(30)
DUNNING_TYPE	VARCHAR2	(10)
LETTER_NAME	VARCHAR2	(50)
NEXT_ACTION	VARCHAR2	(8)
ORG_ID	NUMBER
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
,      RESOURCE_ID
,      CUSTOMER_ID
,      PARTY_NAME
,      FIRST_NAME
,      LAST_NAME
,      PARTY_TYPE
,      ACCOUNT_NUMBER
,      RESOURCE_TYPE
,      DUN_DUNNING_ID
,      DUN_TEMPLATE_ID
,      DUN_DELINQUENCY_ID
,      DATE_TIME
,      STATUS
,      SOURCE_CODE_ID
,      DUN_LAST_UPDATE_DATE
,      DUN_CALLBACK_DATE
,      AGING_BUCKET
,      BUCKET_NAME
,      DUNNING_TYPE
,      LETTER_NAME
,      NEXT_ACTION
,      ORG_ID
,      OPERATING_UNIT_NAME
FROM APPS.IEX_DUNNING_UWQ_V;

Dependencies

[top of page]

APPS.IEX_DUNNING_UWQ_V references the following:

APPS: AR_AGING_BUCKET_LINES_VL; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; HZ_PARTIES; IEX_AG_DN_XREF; IEX_DELINQUENCIES_ALL; IEX_DUNNINGS; IEX_SCORE_HISTORIES; JTF_FM_TEMPLATE; JTF_OBJECTS_B; JTF_RS_RESOURCE_EXTNS

APPS.IEX_DUNNING_UWQ_V is not referenced by any database object