View: OE_OPTION_ITEMS_V

Product:	ONT - Order Management
Description:	View for Option Items LOV
Implementation/DBA Data:	APPS.OE_OPTION_ITEMS_V

View Text

SELECT /*+ NO_EXPAND */ T.DESCRIPTION ITEM_DESCRIPTION
, MIF.ITEM_NUMBER ITEM
, RPAD( '.'
, ( BOM.PLAN_LEVEL - 1 ) * 4
, '.' )|| T.DESCRIPTION PLAN_LEVEL1
, MIF.CUSTOMER_ORDER_ENABLED_FLAG
, BOM.COMPONENT_ITEM_ID
, BOM.COMPONENT_SEQUENCE_ID
, BOM.COMPONENT_CODE
, BOM.SORT_ORDER
, BOM.PLAN_LEVEL
, TO_CHAR(BOM.COMPONENT_QUANTITY) COMPONENT_QUANTITY_D
, BOM.PRIMARY_UNIT_OF_MEASURE
, BOM.PRIMARY_UOM_CODE
, BOM.EXTENDED_QUANTITY ORDERED_QUANTITY
, DECODE(BOM.BOM_ITEM_TYPE
, 1
, 2
, BOM.BOM_ITEM_TYPE) BOM_ITEM_TYPE
, BOM.TOP_BILL_SEQUENCE_ID
, BOM.EFFECTIVITY_DATE
, BOM.DISABLE_DATE
FROM BOM_EXPLOSIONS BOM
, MTL_ITEM_FLEXFIELDS MIF
, MTL_SYSTEM_ITEMS_TL T
WHERE BOM.EXPLOSION_TYPE = 'OPTIONAL'
AND BOM.PLAN_LEVEL > 0
AND ( BOM.OPTIONAL <> 2 OR BOM.BOM_ITEM_TYPE <> 4 )
AND BOM.ORGANIZATION_ID=MIF.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = BOM.COMPONENT_ITEM_ID
AND MIF.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND T.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG') ORDER BY BOM.SORT_ORDER

Columns