View: OKE_SYSTEM_ITEMS_V

Product:	OKE - Project Contracts
Description:	View of Inventory Items
Implementation/DBA Data:	APPS.OKE_SYSTEM_ITEMS_V

View Text

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

Columns