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: PJM.PJM_DEFAULT_TASKS

Object Details

Object Name:	PJM_DEFAULT_TASKS
Object Type:	TABLE
Owner:	PJM
FND Design Data:	PJM.PJM_DEFAULT_TASKS
Subobject Name:
Status:	VALID

PJM_DEFAULT_TASKS stores Task AutoAssignment rules. The rules are maintained through the Task AutoAssignment Rules form and are interpreted by the Task AutoAssignment engine during Cost Collection process, Commitments capture and Invoices Charges transfer.
This table corresponds to the Task AutoAssignment Rules window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJM_DEFAULT_TASKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID ORGANIZATION_ID ASSIGNMENT_TYPE INVENTORY_ITEM_ID CATEGORY_ID PO_HEADER_ID SUBINVENTORY_CODE WIP_ENTITY_PATTERN WIP_MATL_TXN_TYPE PROCURE_FLAG STANDARD_OPERATION_ID ASSEMBLY_ITEM_ID DEPARTMENT_ID TO_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_TYPE	VARCHAR2	(25)	Yes	Task AutoAssignment assignment type
PROJECT_ID	NUMBER		Yes	System-generated number that uniquely identifies a project
TASK_ID	NUMBER		Yes	System-generated number that uniquely identifies a task
ORGANIZATION_ID	NUMBER		Yes	Inventory organization unique identifier
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
INVENTORY_ITEM_ID	NUMBER			Inventory item unique identifier
CATEGORY_ID	NUMBER			Category unique identifier
PO_HEADER_ID	NUMBER			Purchase order header unique identifier
SUBINVENTORY_CODE	VARCHAR2	(10)		Subinventory name
PROCURE_FLAG	VARCHAR2	(1)		Flag indicating procurement activities
STANDARD_OPERATION_ID	NUMBER			Standard operation unique identifier
ASSEMBLY_ITEM_ID	NUMBER			Assembly item unique identifier
DEPARTMENT_ID	NUMBER			Department unique identifier
WIP_ENTITY_PATTERN	VARCHAR2	(240)		Prefix or other matching pattern for the WIP job name
TO_ORGANIZATION_ID	NUMBER			Unique identifier for the transfer-to inventory organization
COMMENTS	VARCHAR2	(240)		User-entered comments
TASK_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context
TASK_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
TASK_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
WIP_MATL_TXN_TYPE	VARCHAR2	(30)		WIP Material Transaction Type

Query Text

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


SELECT ASSIGNMENT_TYPE
,      PROJECT_ID
,      TASK_ID
,      ORGANIZATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      CATEGORY_ID
,      PO_HEADER_ID
,      SUBINVENTORY_CODE
,      PROCURE_FLAG
,      STANDARD_OPERATION_ID
,      ASSEMBLY_ITEM_ID
,      DEPARTMENT_ID
,      WIP_ENTITY_PATTERN
,      TO_ORGANIZATION_ID
,      COMMENTS
,      TASK_ATTRIBUTE_CATEGORY
,      TASK_ATTRIBUTE1
,      TASK_ATTRIBUTE2
,      TASK_ATTRIBUTE3
,      TASK_ATTRIBUTE4
,      TASK_ATTRIBUTE5
,      TASK_ATTRIBUTE6
,      TASK_ATTRIBUTE7
,      TASK_ATTRIBUTE8
,      TASK_ATTRIBUTE9
,      TASK_ATTRIBUTE10
,      TASK_ATTRIBUTE11
,      TASK_ATTRIBUTE12
,      TASK_ATTRIBUTE13
,      TASK_ATTRIBUTE14
,      TASK_ATTRIBUTE15
,      WIP_MATL_TXN_TYPE
FROM PJM.PJM_DEFAULT_TASKS;

Dependencies

[top of page]

PJM.PJM_DEFAULT_TASKS does not reference any database object

PJM.PJM_DEFAULT_TASKS is referenced by following:

APPS: PJM_DEFAULT_TASKS