DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_IH_WRAPUP_OUTCOMES_VL

Object Details
Object Name: JTF_IH_WRAPUP_OUTCOMES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_IH_WRAPUP_OUTCOMES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


View used to drive Outcome LOVs presented in Interaction Wrap-up UIs


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Standard Column
WRAP_ID NUMBER (15) Yes Unique Identifier of the wrap-up.
OBJECT_VERSION_NUMBER NUMBER (9)
Standard Column
CREATED_BY NUMBER (15) Yes Standard Column
CREATION_DATE DATE
Yes Standard Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Column
LAST_UPDATE_DATE DATE
Yes Standard Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Column
RESULT_REQUIRED VARCHAR2 (1)
Indicates if the outcome requires a result value when used.
OUTCOME_ID NUMBER (15)
Identifier of the outcome.
RESULT_ID NUMBER (15)
Identifier of the wrap-up result
REASON_ID NUMBER (15)
Identifier of the wrap-up reason
ACTION_ACTIVITY_ID NUMBER (15)
Obsolete
OBJECT_ID NUMBER (15)
Marketing Source Identifier
OBJECT_TYPE VARCHAR2 (30)
Marketing Source Identifier
SOURCE_CODE_ID NUMBER (15)
Marketing Source Identifier
SOURCE_CODE VARCHAR2 (100)
Marketing Source Identifier
SECURITY_GROUP_ID NUMBER

Standard Column
START_DATE DATE

start date for when the wrap-up should be active and available for use.
END_DATE DATE

End date for when the wrap-up should be inactive and no longer available for use.
WRAP_UP_LEVEL VARCHAR2 (30)
Indicates if the wrap-up can be used on Interactions, Activities or both.
SHORT_DESCRIPTION VARCHAR2 (240) Yes Description of the outcome used in the wrap-up.
VERSATILITY_CODE NUMBER

Obsolete
GENERATE_PUBLIC_CALLBACK VARCHAR2 (1)
Obsolete
GENERATE_PRIVATE_CALLBACK VARCHAR2 (1)
Obsolete
POSITIVE_OUTCOME_FLAG VARCHAR2 (1) Yes Indicates of the outome in the wrap-up is consider a positive outcome (Y/N values)
ACTIVE VARCHAR2 (1)
Indicates if the Outcome in this wrap-up is considered active.
Query Text

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


SELECT ROW_ID
,      WRAP_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESULT_REQUIRED
,      OUTCOME_ID
,      RESULT_ID
,      REASON_ID
,      ACTION_ACTIVITY_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      SOURCE_CODE_ID
,      SOURCE_CODE
,      SECURITY_GROUP_ID
,      START_DATE
,      END_DATE
,      WRAP_UP_LEVEL
,      SHORT_DESCRIPTION
,      VERSATILITY_CODE
,      GENERATE_PUBLIC_CALLBACK
,      GENERATE_PRIVATE_CALLBACK
,      POSITIVE_OUTCOME_FLAG
,      ACTIVE
FROM APPS.JTF_IH_WRAPUP_OUTCOMES_VL;

Dependencies

[top of page]

APPS.JTF_IH_WRAPUP_OUTCOMES_VL references the following:

SchemaAPPS
SynonymJTF_IH_OUTCOMES_B
SynonymJTF_IH_OUTCOMES_TL
SynonymJTF_IH_WRAP_UPS

APPS.JTF_IH_WRAPUP_OUTCOMES_VL is not referenced by any database object