DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 4355: FROM mtl_system_items_vl

4351: oe_debug_pub.add( 'IN OEXVIMSB ITEM IDENTIFIER IS INT' ) ;
4352: END IF;
4353: SELECT inventory_item_id
4354: INTO l_inventory_item_id_int
4355: FROM mtl_system_items_vl
4356: WHERE concatenated_segments = p_x_line_val_tbl(I).inventory_item
4357: AND customer_order_enabled_flag = 'Y'
4358: AND bom_item_type in (1,2,4)
4359: AND organization_id =

Line 4408: FROM mtl_system_items_vl

4404: oe_debug_pub.add( 'IN OEXVIMSB ITEM IDENTIFIER IS INT WITH ORDERED_ITEM' ) ;
4405: END IF;
4406: SELECT inventory_item_id
4407: INTO l_inventory_item_id_ord
4408: FROM mtl_system_items_vl
4409: WHERE concatenated_segments = p_x_line_tbl(I).ordered_item
4410: AND customer_order_enabled_flag = 'Y'
4411: AND bom_item_type in (1,2,4)
4412: AND organization_id =