[Home] [Help] [Dependency Information]
Object Name: | XNB_ITEMMST_CATS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
ITEM_NAME | VARCHAR2 | (40) | Item Name | |
ORGANIZATION_ID | NUMBER | Yes | Operating Unit Id which performed this transaction | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Operating Unit Name which performed this transaction |
ITEM_TYPE | VARCHAR2 | (30) | User-defined item type | |
ITEM_TYPE_DESC | VARCHAR2 | (80) | Description of Item Type | |
BOM_ITEM_TYPE | NUMBER | Yes | Type of item | |
BOM_ITYPE_DESC | VARCHAR2 | (80) | Item Type Description | |
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Primary stocking unit of measure for the item | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure code | |
DESCRIPTION | VARCHAR2 | (240) | Item description is maintained in the installation base language only | |
INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Yes | Material status code |
ITEM_STATUS_DESC | VARCHAR2 | (240) | Material status description | |
START_DATE_ACTIVE | DATE | Flexfield segment start date | ||
END_DATE_ACTIVE | DATE | Flexfield segment end date | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CATEGORY_ID | NUMBER | Yes | Category Id to which the item belongs | |
CATEGORY_DESCRIPTION | VARCHAR2 | (240) | Description of the category | |
CATEGORY_SET_ID | NUMBER | Yes | Category set Id to which the item belongs | |
CATEGORY_SET_NAME | VARCHAR2 | (30) | Yes | Name of the Category Set |
ATTRIBUTE1 | VARCHAR2 | (240) | Attribute1 | |
ATTRIBUTE2 | VARCHAR2 | (240) | Attribute2 | |
ATTRIBUTE3 | VARCHAR2 | (240) | Attribute3 | |
ATTRIBUTE4 | VARCHAR2 | (240) | Attribute4 | |
ATTRIBUTE5 | VARCHAR2 | (240) | Attribute5 | |
ATTRIBUTE6 | VARCHAR2 | (240) | Attribute6 | |
ATTRIBUTE7 | VARCHAR2 | (240) | Attribute7 | |
ATTRIBUTE8 | VARCHAR2 | (240) | Attribute8 | |
ATTRIBUTE9 | VARCHAR2 | (240) | Attribute9 | |
ATTRIBUTE10 | VARCHAR2 | (240) | Attribute10 | |
ATTRIBUTE11 | VARCHAR2 | (240) | Attribute11 | |
ATTRIBUTE12 | VARCHAR2 | (240) | Attribute12 | |
ATTRIBUTE13 | VARCHAR2 | (240) | Attribute13 | |
ATTRIBUTE14 | VARCHAR2 | (240) | Attribute14 | |
ATTRIBUTE15 | VARCHAR2 | (240) | Attribute15 |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ITEM_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, ITEM_TYPE
, ITEM_TYPE_DESC
, BOM_ITEM_TYPE
, BOM_ITYPE_DESC
, PRIMARY_UNIT_OF_MEASURE
, PRIMARY_UOM_CODE
, DESCRIPTION
, INVENTORY_ITEM_STATUS_CODE
, ITEM_STATUS_DESC
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, CREATION_DATE
, CATEGORY_ID
, CATEGORY_DESCRIPTION
, CATEGORY_SET_ID
, CATEGORY_SET_NAME
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM APPS.XNB_ITEMMST_CATS_V;
APPS.XNB_ITEMMST_CATS_V is not referenced by any database object
|
|
|