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]

TABLE: CSP.CSP_PRODUCT_TASKS

Object Details

Object Name:	CSP_PRODUCT_TASKS
Object Type:	TABLE
Owner:	CSP
FND Design Data:	CSP.CSP_PRODUCT_TASKS
Subobject Name:
Status:	VALID

CSP_PRODUCT_TASKS stores the information about Product and Task template used

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSP_PRODUCT_TASKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRODUCT_TASK_ID
CSP_PRODUCT_TASKS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRODUCT_ID TASK_TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRODUCT_TASK_ID	NUMBER	(35)	Yes	Product task unique identifier
PRODUCT_ID	NUMBER	(35)	Yes	Product identifier
TASK_TEMPLATE_ID	NUMBER	(35)	Yes	Task Template Identifier
AUTO_MANUAL	VARCHAR2	(30)	Yes	Manual or Generated
CREATED_BY	NUMBER	(35)	Yes	Standard Who column - with the user id from FND_USER
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(35)	Yes	Standard Who column - with the user id from FND_USER
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(35)		Standard Who column
ACTUAL_TIMES_USED	NUMBER	(35)		Actual number of times the task is used for the product
TASK_PERCENTAGE	NUMBER	(35)		Task percentage for the product
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment Column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment Column
SECURITY_GROUP_ID	NUMBER	(35)		Used in hosted environments

Query Text

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


SELECT PRODUCT_TASK_ID
,      PRODUCT_ID
,      TASK_TEMPLATE_ID
,      AUTO_MANUAL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACTUAL_TIMES_USED
,      TASK_PERCENTAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
FROM CSP.CSP_PRODUCT_TASKS;

Dependencies

[top of page]

CSP.CSP_PRODUCT_TASKS does not reference any database object

CSP.CSP_PRODUCT_TASKS is referenced by following:

APPS: CSP_PRODUCT_TASKS