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

VIEW: APPS.CSF_SR_TASKS_V

Object Details
Object Name: CSF_SR_TASKS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER
Yes Task id
TASK_NUMBER VARCHAR2 (30) Yes Number of the task
TASK_TYPE_ID NUMBER
Yes Task type
TASK_STATUS_ID NUMBER
Yes Task status
TASK_PRIORITY_ID NUMBER

Task priority
OWNER_ID NUMBER
Yes Owner
OWNER_TYPE_CODE VARCHAR2 (30) Yes Owner type
ASSIGNED_BY_ID NUMBER

Assigned by
CUST_ACCOUNT_ID NUMBER

Customer Acccount
CUSTOMER_ID NUMBER

Customer
ADDRESS_ID NUMBER

Address
PARENT_TASK_ID NUMBER

Parent task
SOURCE_OBJECT_TYPE_CODE VARCHAR2 (30)
Source Object type
TIMZONE_ID NUMBER

Timezone Id
SOURCE_OBJECT_ID NUMBER

Source object
SOURCE_OBJECT_NAME VARCHAR2 (80)
Source object name
RESOURCE_ID NUMBER
Yes Resource Id
RESOURCE_TYPE_CODE VARCHAR2 (30) Yes Resource Type Code
Query Text

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


SELECT TASK_ID
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_STATUS_ID
,      TASK_PRIORITY_ID
,      OWNER_ID
,      OWNER_TYPE_CODE
,      ASSIGNED_BY_ID
,      CUST_ACCOUNT_ID
,      CUSTOMER_ID
,      ADDRESS_ID
,      PARENT_TASK_ID
,      SOURCE_OBJECT_TYPE_CODE
,      TIMZONE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      RESOURCE_ID
,      RESOURCE_TYPE_CODE
FROM APPS.CSF_SR_TASKS_V;

Dependencies

[top of page]

APPS.CSF_SR_TASKS_V references the following:

SchemaAPPS
SynonymJTF_TASKS_B
SynonymJTF_TASKS_TL
SynonymJTF_TASK_ASSIGNMENTS
SynonymJTF_TASK_PRIORITIES_TL
SynonymJTF_TASK_STATUSES_B
SynonymJTF_TASK_STATUSES_TL
SynonymJTF_TASK_TYPES_B
SynonymJTF_TASK_TYPES_TL
APPS.CSF_SR_TASKS_V is referenced by following:

SchemaAPPS
ViewCSF_SR_HIST_V