DBA Data[Home] [Help]

APPS.INV_MO_BACKORDER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 422: FROM mtl_system_items

418: DEBUG('g_retain_ato_profile = Y', 'DELETE_DETAILS');
419: BEGIN
420: SELECT 1, primary_uom_code
421: INTO l_ato_item, l_primary_uom
422: FROM mtl_system_items
423: WHERE replenish_to_order_flag = 'Y'
424: AND bom_item_type = 4
425: AND inventory_item_id = l_mtl_reservation_tbl(1).inventory_item_id
426: AND organization_id = l_mtl_reservation_tbl(1).organization_id;