[Home] [Help] [Dependency Information]
Object Name: | CUG_TSK_TYP_ATTR_DEPS_B |
---|---|
Object Type: | TABLE |
Owner: | CUG |
FND Design Data: | CUG.CUG_TSK_TYP_ATTR_DEPS_B |
Subobject Name: | |
Status: | VALID |
The CUG_TSK_TYP_ATTR_DEPS_B Table stores the dependencies between Task Type and Service Request Attributes for a Service Request Type.
The Task Types are associated with the Service Request Types either conditionally or unconditionally. The unconditional association will create the Task Type for the Service Request Type regardless. The conditional association will depend upon the values of Service Request Attributes to be created for a Service Request type when the call center agent creates a Service Request of that Type.
This Table stores the associations between Service Request Type, Task Type, Service Request Attribute Name, Service Request Attribute Value. A Null value of the Service Request Attribute indicates unconditional Task Type.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CUG_TSK_TYP_ATTR_DEPS_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED | TSK_TYP_ATTR_DEP_ID |
CUG_TSK_TYP_ATTR_DEPS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | TASK_TYPE_ID |
CUG_TSK_TYP_ATTR_DEPS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | INCIDENT_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TSK_TYP_ATTR_DEP_ID | NUMBER | (15) | Yes | Primary Key of the Table |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Used for '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 | |
INCIDENT_TYPE_ID | NUMBER | (15) | Yes | Foreign Key to the CS_INCIDENT_TYPES_B Table |
TASK_TYPE_ID | NUMBER | (15) | Yes | Foreign Key to the JTF_TASK_TYPES_B Table |
SR_ATTRIBUTE_CODE | VARCHAR2 | (30) | Foreign key to the FND_LOOKUP_values Table | |
SR_ATTRIBUTE_OPERATOR | VARCHAR2 | (30) | Specifies the relationship between SR_ATTRIBUTE_CODE and SR_ATTRIBUTE_VALUE | |
START_DATE_ACTIVE | DATE | Start Date of the time period for which the Task Type is active for the specified Service Request Type | ||
END_DATE_ACTIVE | DATE | End Date of the time period for which the Task Type is active for the specified Service Request Type | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard Flexfield column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard Flexfield column | |
SECURITY_GROUP_ID | NUMBER | (15) | Security column used by hosted Applications |
Cut, paste (and edit) the following text to query this object:
SELECT TSK_TYP_ATTR_DEP_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, INCIDENT_TYPE_ID
, TASK_TYPE_ID
, SR_ATTRIBUTE_CODE
, SR_ATTRIBUTE_OPERATOR
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
FROM CUG.CUG_TSK_TYP_ATTR_DEPS_B;
CUG.CUG_TSK_TYP_ATTR_DEPS_B does not reference any database object
CUG.CUG_TSK_TYP_ATTR_DEPS_B is referenced by following:
|
|
|