DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 4352: FROM mtl_system_items_vl

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

Line 4405: FROM mtl_system_items_vl

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