[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
PJM.PJM_DEFAULT_TASKS does not reference any database object
PJM.PJM_DEFAULT_TASKS is referenced by following:
|
|
|