VIEW: APPS.OKE_SYSTEM_ITEMS_V

Source

View Text - Preformatted

SELECT B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , B.CONCATENATED_SEGMENTS , T.DESCRIPTION , B.CUSTOMER_ORDER_ENABLED_FLAG , B.PURCHASING_ENABLED_FLAG , B.SHIPPABLE_ITEM_FLAG , B.INVOICEABLE_ITEM_FLAG , B.EFFECTIVITY_CONTROL , B.ITEM_TYPE , B.ENABLED_FLAG , DECODE(B.ENABLED_FLAG , 'Y' , 'A' , 'N' , 'I' , 'I') , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.PRIMARY_UOM_CODE , B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , B.INVENTORY_ITEM_FLAG FROM MTL_SYSTEM_ITEMS_TL T , MTL_SYSTEM_ITEMS_B_KFV B WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND T.LANGUAGE = userenv('LANG') AND B.BOM_ITEM_TYPE = 4

View Text - HTML Formatted

SELECT B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.CONCATENATED_SEGMENTS
, T.DESCRIPTION
, B.CUSTOMER_ORDER_ENABLED_FLAG
, B.PURCHASING_ENABLED_FLAG
, B.SHIPPABLE_ITEM_FLAG
, B.INVOICEABLE_ITEM_FLAG
, B.EFFECTIVITY_CONTROL
, B.ITEM_TYPE
, B.ENABLED_FLAG
, DECODE(B.ENABLED_FLAG
, 'Y'
, 'A'
, 'N'
, 'I'
, 'I')
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.PRIMARY_UOM_CODE
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.INVENTORY_ITEM_FLAG
FROM MTL_SYSTEM_ITEMS_TL T
, MTL_SYSTEM_ITEMS_B_KFV B
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.BOM_ITEM_TYPE = 4