[Home] [Help] [Dependency Information]
Object Name: | IC_COST_CLS_VW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_COST_CLS_VW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
This view is used for backward compatibility for cost classes. It provides the cost class details in the same format as the old IC_COST_CLS table by selecting the data from the OPM Item Category assignments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEMCOST_CLASS | VARCHAR2 | (8) | ||
COST_CATEGORY_ID | NUMBER | |||
COSTCLASS_DESC | VARCHAR2 | (70) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
TRANS_CNT | NUMBER | |||
DELETE_MARK | NUMBER | |||
TEXT_CODE | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (0) | ||
ATTRIBUTE17 | VARCHAR2 | (0) | ||
ATTRIBUTE18 | VARCHAR2 | (0) | ||
ATTRIBUTE19 | VARCHAR2 | (0) | ||
ATTRIBUTE20 | VARCHAR2 | (0) | ||
ATTRIBUTE21 | VARCHAR2 | (0) | ||
ATTRIBUTE22 | VARCHAR2 | (0) | ||
ATTRIBUTE23 | VARCHAR2 | (0) | ||
ATTRIBUTE24 | VARCHAR2 | (0) | ||
ATTRIBUTE25 | VARCHAR2 | (0) | ||
ATTRIBUTE26 | VARCHAR2 | (0) | ||
ATTRIBUTE27 | VARCHAR2 | (0) | ||
ATTRIBUTE28 | VARCHAR2 | (0) | ||
ATTRIBUTE29 | VARCHAR2 | (0) | ||
ATTRIBUTE30 | VARCHAR2 | (0) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ITEMCOST_CLASS
, COST_CATEGORY_ID
, COSTCLASS_DESC
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, TRANS_CNT
, DELETE_MARK
, TEXT_CODE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
FROM APPS.IC_COST_CLS_VW;
|
|
|