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 Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
IEU_OBJECT_PARAMETERS VARCHAR2 (2082)
IEU_MEDIA_TYPE_UUID CHAR (0)
IEU_PARAM_PK_COL CHAR (12)
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)
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

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
,      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
,      DUE_DATE
,      AGING_BUCKET_NAME
,      BUCKET_LINE_DESC
,      TRX_CREATION_DATE
,      DELINQUENCY_ID
,      ORG_ID
,      OPERATING_UNIT_NAME
FROM APPS.IEX_STRATEGIES_UWQ_V;

Dependencies

[top of page]

APPS.IEX_STRATEGIES_UWQ_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES
PL/SQL PackageFND_GLOBAL - show dependent code
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymIEX_DELINQUENCIES
ViewIEX_LOOKUPS_V
SynonymIEX_STRATEGIES
ViewIEX_STRATEGY_TEMPLATES_VL
SynonymIEX_STRATEGY_WORK_ITEMS
ViewIEX_STRY_TEMP_WORK_ITEMS_VL
SynonymJTF_OBJECTS_B
SynonymJTF_RS_RESOURCE_EXTNS
ViewWF_ITEM_TYPES_VL

APPS.IEX_STRATEGIES_UWQ_V is not referenced by any database object