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

VIEW: APPS.CUG_SR_TASK_ATTR_VALS_VL

Object Details
Object Name: CUG_SR_TASK_ATTR_VALS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCUG.CUG_SR_TASK_ATTR_VALS_VL
Subobject Name:
Status: VALID

View Type

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


This view captures the Task Type Attribute and the Value for a given combination of SR Type and Task Type. The Task Type Attribute is obtained based on the various attributes associated with the task type.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
SR_TASK_ATTR_VAL_ID NUMBER (15) Yes Primary Key of the Underlying Base Table
OBJECT_VERSION_NUMBER NUMBER (15)
used by 'stateless' HTML applications
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
TSK_TYP_ATTR_DEPEND_ID NUMBER (15) Yes Foreign key to the CUG_TSK_TYP_ATTR_DEPENDS Table
TASK_TYPE_ATTR_MAP_ID NUMBER (15) Yes Foreign key to the CUG_TASK_TYPE_ATTR_MAPS Table
TASK_TYPE_ATTR_VALUE VARCHAR2 (1997)
Holds the translated value of the Task Type Attribute for the Service Request Type
Query Text

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


SELECT ROW_ID
,      SR_TASK_ATTR_VAL_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      TSK_TYP_ATTR_DEPEND_ID
,      TASK_TYPE_ATTR_MAP_ID
,      TASK_TYPE_ATTR_VALUE
FROM APPS.CUG_SR_TASK_ATTR_VALS_VL;

Dependencies

[top of page]

APPS.CUG_SR_TASK_ATTR_VALS_VL references the following:

SchemaAPPS
SynonymCUG_SR_TASK_ATTR_VALS_B
SynonymCUG_SR_TASK_ATTR_VALS_TL
APPS.CUG_SR_TASK_ATTR_VALS_VL is referenced by following:

SchemaAPPS
Package BodyCUG_WF_EMAIL_UTIL - show dependent code