APPS.GMD_DISP_PUB dependencies on MTL_MATERIAL_STATUSES

Line 413: FROM mtl_material_statuses

409: ) IS
410:
411: CURSOR cr_lot_status IS
412: SELECT status_id, status_code
413: FROM mtl_material_statuses
414: WHERE status_code = p_status
415: AND enabled_flag = 1;
416:
417: CURSOR cr_grade IS

Line 1376: FROM mtl_material_statuses

1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:
1375: SELECT status_id INTO l_to_lot_status_id
1376: FROM mtl_material_statuses
1377: WHERE status_code = p_change_disp_rec.to_lot_status
1378: AND enabled_flag = 1;
1379: END IF;
1380: END IF;