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

TABLE: PJM.PJM_TASK_WIP_ACCT_CLASSES

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


PJM_TASK_WIP_ACCT_CLASSES stores default standard discrete and maintenance WIP accounting classes for a task in each organization.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJM_TASK_WIP_ACCT_CLASS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnORGANIZATION_ID
ColumnTASK_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Inventory organization unique identifier
PROJECT_ID NUMBER
Yes Project unique identifier
TASK_ID NUMBER
Yes Task 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

Standard Who column
WIP_ACCT_CLASS_CODE VARCHAR2 (10)
Default standard discrete accounting class
EAM_ACCT_CLASS_CODE VARCHAR2 (10)
Default maintenance accounting class
Query Text

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


SELECT ORGANIZATION_ID
,      PROJECT_ID
,      TASK_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      WIP_ACCT_CLASS_CODE
,      EAM_ACCT_CLASS_CODE
FROM PJM.PJM_TASK_WIP_ACCT_CLASSES;

Dependencies

[top of page]

PJM.PJM_TASK_WIP_ACCT_CLASSES does not reference any database object

PJM.PJM_TASK_WIP_ACCT_CLASSES is referenced by following:

SchemaPJM
ViewPJM_TASK_WIP_ACCT_CLASSES#