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

TABLE: PJM.PJM_TASK_ATTR_USAGES_B

Object Details
Object Name: PJM_TASK_ATTR_USAGES_B
Object Type: TABLE
Owner: PJM
FND Design Data: TablePJM.PJM_TASK_ATTR_USAGES_B
Subobject Name:
Status: VALID


PJM_TASK_ATTR_USAGES stores the Task AutoAssignment attribute usage and sequencing definition for each assignment type. The usage and sequencing information is used in the Task AutoAssignment Rules form for dynamic painting of the attributes as well as the Task AutoAssignment engine.
This table corresponds to the Task AutoAssign FlexSequence window.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJM_TASK_ATTR_USAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnASSIGNMENT_TYPE
ColumnATTRIBUTE_CODE
PJM_TASK_ATTR_USAGES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnASSIGNMENT_TYPE
ColumnSEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_TYPE VARCHAR2 (25) Yes Task AutoAssignment assignment type
ATTRIBUTE_CODE VARCHAR2 (30) Yes Internal code for Task AutoAssignment attribute
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

Standard Who column
SEQUENCE_NUMBER NUMBER (15) Yes FlexSequence number
PROMPT VARCHAR2 (30)
No longer used
Query Text

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


SELECT ASSIGNMENT_TYPE
,      ATTRIBUTE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEQUENCE_NUMBER
,      PROMPT
FROM PJM.PJM_TASK_ATTR_USAGES_B;

Dependencies

[top of page]

PJM.PJM_TASK_ATTR_USAGES_B does not reference any database object

PJM.PJM_TASK_ATTR_USAGES_B is referenced by following:

SchemaAPPS
SynonymPJM_TASK_ATTR_USAGES_B