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_STRATEGIES_UWQ_V

Object Details

Object Name:	IEX_STRATEGIES_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
IEU_OBJECT_FUNCTION	VARCHAR2	(30)
IEU_OBJECT_PARAMETERS	VARCHAR2	(2102)
IEU_MEDIA_TYPE_UUID	CHAR	(0)
IEU_PARAM_PK_COL	VARCHAR2	(15)
IEU_PARAM_PK_VALUE	VARCHAR2	(40)
RESOURCE_ID	NUMBER
CUSTOMER_ID	NUMBER	(15)
CUSTOMER_NAME	VARCHAR2	(360)
FIRST_NAME	VARCHAR2	(150)
LAST_NAME	VARCHAR2	(150)
RESOURCE_TYPE	CHAR	(13)
STRATEGY_ID	NUMBER	(25)
STRATEGY_TEMPLATE_ID	NUMBER	(25)
STRATEGY_NAME	VARCHAR2	(240)
WKITEM_ORDER	NUMBER	(15)
WKITEM_ID	NUMBER	(25)
WKITEM_TEMPLATE_ID	NUMBER	(25)
WKITEM_TEMPLATE_NAME	VARCHAR2	(240)
CATEGORY_MEANING	VARCHAR2	(80)
CATEGORY	VARCHAR2	(30)
START_TIME	DATE
END_TIME	DATE
ASSIGNED_TO	NUMBER
ASSIGNEE	VARCHAR2	(360)
WORK_TYPE	VARCHAR2	(30)
ESCALATE_YN	VARCHAR2	(6)
WORKFLOW_ITEM_TYPE	VARCHAR2	(80)
STATUS	VARCHAR2	(80)
STRATEGY_USER_ITEM_ID	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
SCHEDULE_START	DATE
SCHEDULE_END	DATE
JTF_OBJECT_TYPE	VARCHAR2	(30)
JTF_OBJECT_ID	NUMBER	(15)
STRATEGY_LEVEL	NUMBER
UWQ_STATUS	VARCHAR2	(240)
UWQ_ACTIVE_DATE	DATE
UWQ_COMPLETE_DATE	DATE
TRX_NUMBER	VARCHAR2	(30)
AMOUNT_DUE_ORIGINAL	NUMBER
AMOUNT_DUE_REMAINING	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
DUE_DATE	DATE
AGING_BUCKET_NAME	VARCHAR2	(0)
BUCKET_LINE_DESC	VARCHAR2	(0)
TRX_CREATION_DATE	VARCHAR2	(0)
DELINQUENCY_ID	NUMBER
ORG_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)

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
,      CUSTOMER_NAME
,      FIRST_NAME
,      LAST_NAME
,      RESOURCE_TYPE
,      STRATEGY_ID
,      STRATEGY_TEMPLATE_ID
,      STRATEGY_NAME
,      WKITEM_ORDER
,      WKITEM_ID
,      WKITEM_TEMPLATE_ID
,      WKITEM_TEMPLATE_NAME
,      CATEGORY_MEANING
,      CATEGORY
,      START_TIME
,      END_TIME
,      ASSIGNED_TO
,      ASSIGNEE
,      WORK_TYPE
,      ESCALATE_YN
,      WORKFLOW_ITEM_TYPE
,      STATUS
,      STRATEGY_USER_ITEM_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SCHEDULE_START
,      SCHEDULE_END
,      JTF_OBJECT_TYPE
,      JTF_OBJECT_ID
,      STRATEGY_LEVEL
,      UWQ_STATUS
,      UWQ_ACTIVE_DATE
,      UWQ_COMPLETE_DATE
,      TRX_NUMBER
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_DUE_REMAINING
,      CURRENCY_CODE
,      DUE_DATE
,      AGING_BUCKET_NAME
,      BUCKET_LINE_DESC
,      TRX_CREATION_DATE
,      DELINQUENCY_ID
,      ORG_ID
,      OPERATING_UNIT_NAME
FROM APPS.IEX_STRATEGIES_UWQ_V;