[Home] [Help] [Dependency Information]
Object Name: | ASL_INVENTORY_ITEM_DENORM |
---|---|
Object Type: | TABLE |
Owner: | ASL |
Subobject Name: | |
Status: | VALID |
ASL_INVENTORY_ITEM_DENORM table contains all the categories pertaining to the given inventory organization id and category set.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASL_INVENTORY_ITEM_DENORM_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
CATEGORY_SET_ID CATEGORY_ID LANGUAGE_CODE LAST_UPDATE_DATE |
ASL_INVENTORY_ITEM_DENORM_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
CATEGORY_ID INVENTORY_ITEM_ID LANGUAGE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY_SET_ID | NUMBER | (15) | Category Set Id | |
CATEGORY_ID | NUMBER | (15) | Category Id | |
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | Inventory Item Id |
ORGANIZATION_ID | NUMBER | (15) | Organization Id | |
LAST_UPDATE_DATE | DATE | Yes | LAST UPDATE DATE | |
CREATION_DATE | DATE | Yes | Creation Date | |
INVENTORY_ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Description of the item | |
LANGUAGE_CODE | VARCHAR2 | (240) | Yes | Language Code |
UOM_CODE | VARCHAR2 | (240) | Uom Code | |
UOM_DESCRIPTION | VARCHAR2 | (50) | UOM DESCRIPTION | |
INTEREST_TYPE_ID | NUMBER | (15) | Interest Type Id | |
INTEREST_TYPE | VARCHAR2 | (240) | Interest Type | |
PRIMARY_INTEREST_CODE_ID | NUMBER | (15) | Primary Interest Code Id | |
PRIMARY_INTEREST_CODE | VARCHAR2 | (240) | Primary Interest Code | |
SECONDARY_INTEREST_CODE_ID | NUMBER | (15) | Secondary Interest Code Id | |
SECONDARY_INTEREST_CODE | VARCHAR2 | (240) | Secondary Interest Code | |
SHIPPLE_FLAG | VARCHAR2 | (1) | Shipple Flag | |
SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Service Item Flag | |
TAXABLE_FLAG | VARCHAR2 | (1) | Taxable Flag | |
RETURNABLE_FLAG | VARCHAR2 | (1) | Returnable Flag | |
SERVICEABLE_FLAG | VARCHAR2 | (1) | Serviceable Flag | |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Active Flag |
BOM_ENABLED_FLAG | VARCHAR2 | (10) | BOM Enabled Flag | |
VENDOR_WARRANTY_FLAG | VARCHAR2 | (1) | Vendor Warranty Flag | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM Code |
Cut, paste (and edit) the following text to query this object:
SELECT CATEGORY_SET_ID
, CATEGORY_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, CREATION_DATE
, INVENTORY_ITEM_NUMBER
, ITEM_DESCRIPTION
, LANGUAGE_CODE
, UOM_CODE
, UOM_DESCRIPTION
, INTEREST_TYPE_ID
, INTEREST_TYPE
, PRIMARY_INTEREST_CODE_ID
, PRIMARY_INTEREST_CODE
, SECONDARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE
, SHIPPLE_FLAG
, SERVICE_ITEM_FLAG
, TAXABLE_FLAG
, RETURNABLE_FLAG
, SERVICEABLE_FLAG
, ACTIVE_FLAG
, BOM_ENABLED_FLAG
, VENDOR_WARRANTY_FLAG
, PRIMARY_UOM_CODE
FROM ASL.ASL_INVENTORY_ITEM_DENORM;
ASL.ASL_INVENTORY_ITEM_DENORM does not reference any database object
ASL.ASL_INVENTORY_ITEM_DENORM is referenced by following:
|
|
|