eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSF_CT_TASKS

Object Details

Object Name:	CSF_CT_TASKS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSF.CSF_CT_TASKS
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
ROW_ID	ROWID	(10)		Row Identification
TASK_ID	NUMBER		Yes	Task Id
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_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
TASK_NUMBER	VARCHAR2	(30)	Yes	Task Number
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 Id
OWNER_TYPE_CODE	VARCHAR2	(30)	Yes	Owner Type Code
ASSIGNED_BY_ID	NUMBER			Assigned By
CUST_ACCOUNT_ID	NUMBER			Customer Account Id
CUSTOMER_ID	NUMBER			Customer Id
ADDRESS_ID	NUMBER			Address Id
PARENT_TASK_ID	NUMBER			Parent Task Id
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Source Object Type Code
TIMEZONE_ID	NUMBER			Time zone Id
SOURCE_OBJECT_ID	NUMBER			Source Object Id
SOURCE_OBJECT_NAME	VARCHAR2	(80)		Source Object Name
DURATION	NUMBER			Duration
DURATION_UOM	VARCHAR2	(3)		Duration UOM
PLANNED_EFFORT	NUMBER			Planned Effort
PLANNED_EFFORT_UOM	VARCHAR2	(3)		Planned Effort UOM
ACTUAL_EFFORT	NUMBER			Actual Effort
ACTUAL_EFFORT_UOM	VARCHAR2	(3)		Actual Effort UOM
PLANNED_START_DATE	DATE			Planned Start Date
PLANNED_END_DATE	DATE			Planned End Date
SCHEDULED_START_DATE	DATE			Scheduled Start Date
SCHEDULED_END_DATE	DATE			Scheduled End Date
ACTUAL_START_DATE	DATE			Actual Start Date
ACTUAL_END_DATE	DATE			Actual End Date
TASK_NAME	VARCHAR2	(80)	Yes	Task Name
DESCRIPTION	VARCHAR2	(4000)		Description
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
OWNER_TERRITORY_ID	NUMBER			Owner Territory Id
TASK_STATUS	VARCHAR2	(30)	Yes	Task Status
STATUS_SCHEDULABLE_FLAG	VARCHAR2	(1)		Status Schedulable Flag
TASK_TYPE	VARCHAR2	(30)	Yes	Task Type
TYPE_SCHEDULABLE_FLAG	VARCHAR2	(1)		Type Schedulable Flag
TASK_PRIORITY	VARCHAR2	(30)		Task Priority
ORG_ID	NUMBER			Organization Id
INCIDENT_ID	NUMBER	(15)	Yes	Incident ID
INCIDENT_NUMBER	VARCHAR2	(64)	Yes	Incident Number
INCIDENT_CUSTOMER_ID	NUMBER	(15)		Incident Customer Id
INCIDENT_ACCOUNT_ID	NUMBER			Incident Account Id
INCIDENT_CREATION_DATE	DATE		Yes	Service Request Creation Date
CONTRACT_SERVICE_ID	NUMBER			Contract Service Id
INCIDENT_URGENCY_ID	NUMBER	(15)		Urgency Id
OBLIGATION_DATE	DATE			Obligation Date
PROBLEM_CODE	VARCHAR2	(50)		Problem Code
RESOLUTION_CODE	VARCHAR2	(50)		Resolution Code
CUSTOMER_PRODUCT_ID	NUMBER	(15)		Customer Product Id
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		Current Serial Number
PRODUCT_REVISION	VARCHAR2	(240)		Product Revision
INV_ITEM_REVISION	VARCHAR2	(240)		Inventory Item Revision
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory Item Id
INV_ORGANIZATION_ID	NUMBER			Inventory Organization Id
INSTALLED_BASE_FLAG	VARCHAR2	(1)		Installed base Flag
SUMMARY	VARCHAR2	(240)	Yes	Summary
INCIDENT_CUSTOMER_NAME	VARCHAR2	(360)		Incident Customer Name
PRODUCT_NAME	VARCHAR2	(40)		Product Name
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Product Description
REVISION_QTY_CONTROL_CODE	NUMBER			Revision Quantity Control Code
LOCATION_ID	NUMBER	(15)		Location Id
ADDRESS1	VARCHAR2	(240)		Address1
ADDRESS2	VARCHAR2	(240)		Address2
POSTAL_CODE	VARCHAR2	(60)		Postal Code
CITY	VARCHAR2	(60)		City
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
COUNTRY	VARCHAR2	(60)		Country
ADDRESS3	VARCHAR2	(240)		Address3
ADDRESS4	VARCHAR2	(240)		Address4
COUNTY	VARCHAR2	(60)		County
TASK_SPLIT_FLAG	VARCHAR2	(1)		Task Split Flag
PARTY_NUMBER	VARCHAR2	(30)		Party Number
CLOSED_FLAG	VARCHAR2	(1)		Closed Flag
ASSIGNED_FLAG	VARCHAR2	(1)		Assigned Flag
INCIDENT_TYPE_ID	NUMBER	(15)	Yes	Incident Type Id
INCIDENT_TYPE_NAME	VARCHAR2	(90)	Yes	Incident Type Name
OPEN_FLAG	VARCHAR2	(1)		Open Flag
START_DATE_TYPE	VARCHAR2	(30)		Start Date Type
END_DATE_TYPE	VARCHAR2	(30)		End Date Type
TASK_TIMEZONE_ID	NUMBER			Task Timezone Id
WORKING_FLAG	VARCHAR2	(1)		Working Flag
REJECTED_FLAG	VARCHAR2	(1)		Rejected Flag
COMPLETED_FLAG	VARCHAR2	(1)		Completed Flag

Query Text

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


SELECT ROW_ID
,      TASK_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      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
,      TIMEZONE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_NAME
,      DURATION
,      DURATION_UOM
,      PLANNED_EFFORT
,      PLANNED_EFFORT_UOM
,      ACTUAL_EFFORT
,      ACTUAL_EFFORT_UOM
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      TASK_NAME
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      OWNER_TERRITORY_ID
,      TASK_STATUS
,      STATUS_SCHEDULABLE_FLAG
,      TASK_TYPE
,      TYPE_SCHEDULABLE_FLAG
,      TASK_PRIORITY
,      ORG_ID
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      INCIDENT_CUSTOMER_ID
,      INCIDENT_ACCOUNT_ID
,      INCIDENT_CREATION_DATE
,      CONTRACT_SERVICE_ID
,      INCIDENT_URGENCY_ID
,      OBLIGATION_DATE
,      PROBLEM_CODE
,      RESOLUTION_CODE
,      CUSTOMER_PRODUCT_ID
,      CURRENT_SERIAL_NUMBER
,      PRODUCT_REVISION
,      INV_ITEM_REVISION
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      INSTALLED_BASE_FLAG
,      SUMMARY
,      INCIDENT_CUSTOMER_NAME
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      REVISION_QTY_CONTROL_CODE
,      LOCATION_ID
,      ADDRESS1
,      ADDRESS2
,      POSTAL_CODE
,      CITY
,      STATE
,      PROVINCE
,      COUNTRY
,      ADDRESS3
,      ADDRESS4
,      COUNTY
,      TASK_SPLIT_FLAG
,      PARTY_NUMBER
,      CLOSED_FLAG
,      ASSIGNED_FLAG
,      INCIDENT_TYPE_ID
,      INCIDENT_TYPE_NAME
,      OPEN_FLAG
,      START_DATE_TYPE
,      END_DATE_TYPE
,      TASK_TIMEZONE_ID
,      WORKING_FLAG
,      REJECTED_FLAG
,      COMPLETED_FLAG
FROM APPS.CSF_CT_TASKS;

Dependencies

[top of page]

APPS.CSF_CT_TASKS references the following:

APPS: CSF_TASKS_PUB - show dependent code; CS_INCIDENTS_ALL_B; CS_INCIDENTS_ALL_TL; CS_INCIDENT_TYPES_TL; HZ_LOCATIONS; HZ_PARTIES; JTF_TASKS_B; JTF_TASKS_TL; JTF_TASK_PRIORITIES_TL; JTF_TASK_STATUSES_B; JTF_TASK_STATUSES_TL; JTF_TASK_TYPES_B; JTF_TASK_TYPES_TL; MTL_SYSTEM_ITEMS_KFV

APPS.CSF_CT_TASKS is not referenced by any database object