DBA Data[Home] [Help]

APPS.OE_CNCL_VALUE_TO_ID dependencies on MTL_SYSTEM_ITEMS_VL

Line 2564: FROM mtl_system_items_vl

2560:
2561: --bug5603389
2562: SELECT inventory_item_id
2563: INTO l_id
2564: FROM mtl_system_items_vl
2565: WHERE concatenated_segments =p_inventory_item
2566: AND customer_order_enabled_flag = 'Y'
2567: AND bom_item_type in (1,2,4)
2568: AND organization_id = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');