DBA Data[Home] [Help]

APPS.AMS_METRIC_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 2509: SELECT 1 from MTL_UNITS_OF_MEASURE

2505:
2506:
2507:
2508: CURSOR c_check_uom(p_uom_code varchar2,p_uom_class varchar2 ) IS
2509: SELECT 1 from MTL_UNITS_OF_MEASURE
2510: WHERE UOM_CODE = p_uom_code
2511: AND uom_class = p_uom_class;
2512:
2513: /*sunkumar 20 april 2004*/

Line 2617: /* l_table_name := 'MTL_UNITS_OF_MEASURE';

2613:
2614: -- IF l_metrics_rec.uom_type = FND_API.G_MISS_CHAR THEN
2615: -- l_metrics_rec.uom_type := p_complete_rec.uom_type ;
2616: -- END IF;
2617: /* l_table_name := 'MTL_UNITS_OF_MEASURE';
2618: l_pk_name := 'UOM_CODE';
2619: l_pk_value := p_complete_rec.default_uom_code;
2620: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2621: l_additional_where_clause := ' uom_class = '''||p_complete_rec.uom_type||'''';