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: INV.MTL_ITEM_CHILD_INFO_INTERFACE

Object Details

Object Name:	MTL_ITEM_CHILD_INFO_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_ITEM_CHILD_INFO_INTERFACE
Subobject Name:
Status:	VALID

MTL_ITEM_CHILD_INFO_INTERFACE temporarily stores detail information
for your items such as subinventories, locators, category sets,
categories, and costing information. After the proper validation,
Oracle Inventory inserts records into MTL_ITEM_SUB_INVENTORIES,
MTL_SECONDARY_LOCATORS, MTL_ITEM_CATEGORIES, CST_ITEM_COSTS and
CST_ITEM_COST_DETAILS respectively.
.
This table contains user friendly columns which allow you to easily
enter your data as well as their corresponding foreign keys. Oracle
Inventory will fill in the column you do not enter after performing
the proper validation. For example, you enter the ITEM_NUMBER and
Oracle Inventory will fill in the corresponding INVENTORY_ITEM_ID
for you.
.
This table is not currently used.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
ITEM_NUMBER	VARCHAR2	(81)	Concatenated item segments
ORGANIZATION_ID	NUMBER		Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Abbreviation of organization name
TRANSACTION_ID	NUMBER		Row identifier
PROCESS_FLAG	NUMBER		Row status
SUBINVENTORY1	VARCHAR2	(10)	First subinventory
SUBINVENTORY2	VARCHAR2	(10)	Second subinventory
SUBINVENTORY3	VARCHAR2	(10)	Third subinventory
SUBINVENTORY4	VARCHAR2	(10)	Fourth subinventory
SUBINVENTORY5	VARCHAR2	(10)	Fifth subinventory
CATEGORY_SET_ID1	NUMBER		First category set identifier
CATEGORY_SET_ID2	NUMBER		Second category set identifier
CATEGORY_SET_ID3	NUMBER		Third category set identifier
CATEGORY_SET_ID4	NUMBER		Fourth category set identifier
CATEGORY_SET_ID5	NUMBER		Fifth category set identifier
CATEGORY_SET_NAME1	VARCHAR2	(10)	First category set name
CATEGORY_SET_NAME2	VARCHAR2	(10)	Second category set name
CATEGORY_SET_NAME3	VARCHAR2	(10)	Third category set name
CATEGORY_SET_NAME4	VARCHAR2	(10)	Fourth category set name
CATEGORY_SET_NAME5	VARCHAR2	(10)	Fifth category set name
CATEGORY_ID1	NUMBER		First category identifier
CATEGORY_ID2	NUMBER		Second category identifier
CATEGORY_ID3	NUMBER		Third category identifier
CATEGORY_ID4	NUMBER		Fourth category identifier
CATEGORY_ID5	NUMBER		Fifth category identifier
CATEGORY_NAME1	VARCHAR2	(81)	First category name
CATEGORY_NAME2	VARCHAR2	(81)	Second category name
CATEGORY_NAME3	VARCHAR2	(81)	Third category name
CATEGORY_NAME4	VARCHAR2	(81)	Fourth category name
CATEGORY_NAME5	VARCHAR2	(81)	Fifth category name
MATERIAL_COST	NUMBER		Material cost
MATERIAL_SUB_ELEM_ID	NUMBER		Material sub-element identifier
MATERIAL_SUB_ELEM	VARCHAR2	(50)	Material sub-element
MATERIAL_OH_COST	NUMBER		Material overhead cost
MATERIAL_OH_SUB_ELEM_ID	NUMBER		Material overhead sub-element identifier
MATERIAL_OH_SUB_ELEM	VARCHAR2	(50)	Material overhead sub-element
LOCATOR_ID1	NUMBER		First locator identifier
LOCATOR_ID2	NUMBER		Second locator identifier
LOCATOR_ID3	NUMBER		Third locator identifier
LOCATOR_ID4	NUMBER		Fourth locator identifier
LOCATOR_ID5	NUMBER		Fifth locator identifier
LOCATOR_NAME1	VARCHAR2	(81)	First locator name
LOCATOR_NAME2	VARCHAR2	(81)	Second locator name
LOCATOR_NAME3	VARCHAR2	(81)	Third locator name
LOCATOR_NAME4	VARCHAR2	(81)	Fourth locator name
LOCATOR_NAME5	VARCHAR2	(81)	Fifth locator name
TRANSACTION_TYPE	VARCHAR2	(10)	Specifies a type of transaction to be performed on the interface record (e.g. CREATE)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      TRANSACTION_ID
,      PROCESS_FLAG
,      SUBINVENTORY1
,      SUBINVENTORY2
,      SUBINVENTORY3
,      SUBINVENTORY4
,      SUBINVENTORY5
,      CATEGORY_SET_ID1
,      CATEGORY_SET_ID2
,      CATEGORY_SET_ID3
,      CATEGORY_SET_ID4
,      CATEGORY_SET_ID5
,      CATEGORY_SET_NAME1
,      CATEGORY_SET_NAME2
,      CATEGORY_SET_NAME3
,      CATEGORY_SET_NAME4
,      CATEGORY_SET_NAME5
,      CATEGORY_ID1
,      CATEGORY_ID2
,      CATEGORY_ID3
,      CATEGORY_ID4
,      CATEGORY_ID5
,      CATEGORY_NAME1
,      CATEGORY_NAME2
,      CATEGORY_NAME3
,      CATEGORY_NAME4
,      CATEGORY_NAME5
,      MATERIAL_COST
,      MATERIAL_SUB_ELEM_ID
,      MATERIAL_SUB_ELEM
,      MATERIAL_OH_COST
,      MATERIAL_OH_SUB_ELEM_ID
,      MATERIAL_OH_SUB_ELEM
,      LOCATOR_ID1
,      LOCATOR_ID2
,      LOCATOR_ID3
,      LOCATOR_ID4
,      LOCATOR_ID5
,      LOCATOR_NAME1
,      LOCATOR_NAME2
,      LOCATOR_NAME3
,      LOCATOR_NAME4
,      LOCATOR_NAME5
,      TRANSACTION_TYPE
FROM INV.MTL_ITEM_CHILD_INFO_INTERFACE;

Dependencies

[top of page]

INV.MTL_ITEM_CHILD_INFO_INTERFACE does not reference any database object

INV.MTL_ITEM_CHILD_INFO_INTERFACE is referenced by following:

APPS: MTL_ITEM_CHILD_INFO_INTERFACE