SELECT M.INVENTORY_ITEM_ID,M.ORGANIZATION_ID,SEGMENT1,BOM_ITEM_TYPE, FIXED_LEAD_TIME,START_DATE_ACTIVE,END_DATE_ACTIVE, CUSTOMER_ORDER_ENABLED_FLAG, T.DESCRIPTION AS ITEM_DESC, INVENTORY_ITEM_STATUS_CODE,ITEM_CATALOG_GROUP_ID,CONCATENATED_SEGMENTS, INDIVISIBLE_FLAG FROM MTL_SYSTEM_ITEMS_KFV M , MTL_SYSTEM_ITEMS_TL T WHERE M.ORGANIZATION_ID = T.ORGANIZATION_ID AND M.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND T.LANGUAGE = userenv('LANG')
SELECT M.INVENTORY_ITEM_ID
, M.ORGANIZATION_ID
, SEGMENT1
, BOM_ITEM_TYPE
, FIXED_LEAD_TIME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CUSTOMER_ORDER_ENABLED_FLAG
, T.DESCRIPTION AS ITEM_DESC
, INVENTORY_ITEM_STATUS_CODE
, ITEM_CATALOG_GROUP_ID
, CONCATENATED_SEGMENTS
, INDIVISIBLE_FLAG
FROM MTL_SYSTEM_ITEMS_KFV M
, MTL_SYSTEM_ITEMS_TL T
WHERE M.ORGANIZATION_ID = T.ORGANIZATION_ID
AND M.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|