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

VIEW: APPS.JTF_IH_WRAPUP_RESULTS_VL

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

View Type

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


View used to drive Result 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 result requires a reason 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.
GENERATE_PUBLIC_CALLBACK VARCHAR2 (1)
Obsolete
SHORT_DESCRIPTION VARCHAR2 (240)
Description of the outcome used in the wrap-up.
GENERATE_PRIVATE_CALLBACK VARCHAR2 (1)
Obsolete
VERSATILITY_CODE NUMBER

Obsolete
POSITIVE_RESPONSE_FLAG VARCHAR2 (1) Yes Indicates of the result in the wrap-up indicates a positive response (Y/N values)
ACTIVE VARCHAR2 (1)
Indicates if the Result in this wrap-up is considered active.
WRAP_UP_LEVEL VARCHAR2 (30)
Indicates if the wrap-up can be used on Interactions, Activities or both.
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
,      GENERATE_PUBLIC_CALLBACK
,      SHORT_DESCRIPTION
,      GENERATE_PRIVATE_CALLBACK
,      VERSATILITY_CODE
,      POSITIVE_RESPONSE_FLAG
,      ACTIVE
,      WRAP_UP_LEVEL
FROM APPS.JTF_IH_WRAPUP_RESULTS_VL;

Dependencies

[top of page]

APPS.JTF_IH_WRAPUP_RESULTS_VL references the following:

SchemaAPPS
SynonymJTF_IH_RESULTS_B
SynonymJTF_IH_RESULTS_TL
SynonymJTF_IH_WRAP_UPS

APPS.JTF_IH_WRAPUP_RESULTS_VL is not referenced by any database object