[Home] [Help] [Dependency Information]
Object Name: | WIP_DEF_CAT_ACC_CLASSES |
---|---|
Object Type: | TABLE |
Owner: | WIP |
FND Design Data: | WIP.WIP_DEF_CAT_ACC_CLASSES |
Subobject Name: | |
Status: | VALID |
WIP_DEF_CAT_ACC_CLASSES stores accounting classes by category and
possibly by cost group. Information is entered into this table using
the Default WIP Accounting Classes for Categories window in Oracle
Cost Management.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WIP_DEF_CAT_ACC_CLASSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
CATEGORY_ID COST_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_ID | NUMBER | Yes | Category Identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
COST_GROUP_ID | NUMBER | Cost Group Identifier | ||
STD_DISCRETE_CLASS | VARCHAR2 | (10) | Standard discrete WIP accounting class | |
REPETITIVE_ASSY_CLASS | VARCHAR2 | (10) | Repetitive assembly WIP accounting class | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
REQUEST_ID | NUMBER | Enhanced Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who column | ||
PROGRAM_ID | NUMBER | Enhanced Who column | ||
PROGRAM_UPDATE_DATE | DATE | Enhanced Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_ID
, ORGANIZATION_ID
, COST_GROUP_ID
, STD_DISCRETE_CLASS
, REPETITIVE_ASSY_CLASS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM WIP.WIP_DEF_CAT_ACC_CLASSES;
WIP.WIP_DEF_CAT_ACC_CLASSES does not reference any database object
WIP.WIP_DEF_CAT_ACC_CLASSES is referenced by following:
|
|
|