VIEW: APPS.OE_OPTION_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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