[Home] [Help] [Dependency Information]
Object Name: | IC_STOR_CLS_VW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_STOR_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 storage classes. It provides the storage class details in the same format as the old IC_STOR_CLS table by selecting the data from the OPM Item Category assignments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ICSTORAGE_CLASS | VARCHAR2 | (8) | ||
STORAGE_CATEGORY_ID | NUMBER | |||
ICSTORAGE_CLASS_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 ICSTORAGE_CLASS
, STORAGE_CATEGORY_ID
, ICSTORAGE_CLASS_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_STOR_CLS_VW;
|
|
|