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.

[Home] [Help]

VIEW: INV.MTL_ITEM_CHILD_INFO_INTERFACE#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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