eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ASL.ASL_INVENTORY_ITEM_DENORM

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

ASL.ASL_INVENTORY_ITEM_DENORM does not reference any database object

ASL.ASL_INVENTORY_ITEM_DENORM is referenced by following:

ASL: ASL_INVENTORY_ITEM_DENORM#