[Home] [Help] [Dependency Information]
Object Name: | IC_FRGT_CLS_VW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMI.IC_FRGT_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 freight classes. It provides the freight class details in the same format as the old IC_FRGT_CLS table by selecting the data from the OPM Item Category assignments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ICFRT_CLASS | VARCHAR2 | (8) | ||
FRT_CATEGORY_ID | NUMBER | |||
ICFRT_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 ICFRT_CLASS
, FRT_CATEGORY_ID
, ICFRT_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_FRGT_CLS_VW;
|
|
|