[Home] [Help] [Dependency Information]
Object Name: | MTL_ITEM_CHILD_INFO_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | INV |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (81) | ||
ORGANIZATION_ID | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
TRANSACTION_ID | NUMBER | |||
PROCESS_FLAG | NUMBER | |||
SUBINVENTORY1 | VARCHAR2 | (10) | ||
SUBINVENTORY2 | VARCHAR2 | (10) | ||
SUBINVENTORY3 | VARCHAR2 | (10) | ||
SUBINVENTORY4 | VARCHAR2 | (10) | ||
SUBINVENTORY5 | VARCHAR2 | (10) | ||
CATEGORY_SET_ID1 | NUMBER | |||
CATEGORY_SET_ID2 | NUMBER | |||
CATEGORY_SET_ID3 | NUMBER | |||
CATEGORY_SET_ID4 | NUMBER | |||
CATEGORY_SET_ID5 | NUMBER | |||
CATEGORY_SET_NAME1 | VARCHAR2 | (10) | ||
CATEGORY_SET_NAME2 | VARCHAR2 | (10) | ||
CATEGORY_SET_NAME3 | VARCHAR2 | (10) | ||
CATEGORY_SET_NAME4 | VARCHAR2 | (10) | ||
CATEGORY_SET_NAME5 | VARCHAR2 | (10) | ||
CATEGORY_ID1 | NUMBER | |||
CATEGORY_ID2 | NUMBER | |||
CATEGORY_ID3 | NUMBER | |||
CATEGORY_ID4 | NUMBER | |||
CATEGORY_ID5 | NUMBER | |||
CATEGORY_NAME1 | VARCHAR2 | (81) | ||
CATEGORY_NAME2 | VARCHAR2 | (81) | ||
CATEGORY_NAME3 | VARCHAR2 | (81) | ||
CATEGORY_NAME4 | VARCHAR2 | (81) | ||
CATEGORY_NAME5 | VARCHAR2 | (81) | ||
MATERIAL_COST | NUMBER | |||
MATERIAL_SUB_ELEM_ID | NUMBER | |||
MATERIAL_SUB_ELEM | VARCHAR2 | (50) | ||
MATERIAL_OH_COST | NUMBER | |||
MATERIAL_OH_SUB_ELEM_ID | NUMBER | |||
MATERIAL_OH_SUB_ELEM | VARCHAR2 | (50) | ||
LOCATOR_ID1 | NUMBER | |||
LOCATOR_ID2 | NUMBER | |||
LOCATOR_ID3 | NUMBER | |||
LOCATOR_ID4 | NUMBER | |||
LOCATOR_ID5 | NUMBER | |||
LOCATOR_NAME1 | VARCHAR2 | (81) | ||
LOCATOR_NAME2 | VARCHAR2 | (81) | ||
LOCATOR_NAME3 | VARCHAR2 | (81) | ||
LOCATOR_NAME4 | VARCHAR2 | (81) | ||
LOCATOR_NAME5 | VARCHAR2 | (81) | ||
TRANSACTION_TYPE | VARCHAR2 | (10) |
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#;
|
|
|