DBA Data[Home] [Help]

APPS.AMS_METRIC_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 2502: SELECT 1 from MTL_UNITS_OF_MEASURE

2498:
2499:
2500:
2501: CURSOR c_check_uom(p_uom_code varchar2,p_uom_class varchar2 ) IS
2502: SELECT 1 from MTL_UNITS_OF_MEASURE
2503: WHERE UOM_CODE = p_uom_code
2504: AND uom_class = p_uom_class;
2505:
2506: /*sunkumar 20 april 2004*/

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

2606:
2607: -- IF l_metrics_rec.uom_type = FND_API.G_MISS_CHAR THEN
2608: -- l_metrics_rec.uom_type := p_complete_rec.uom_type ;
2609: -- END IF;
2610: /* l_table_name := 'MTL_UNITS_OF_MEASURE';
2611: l_pk_name := 'UOM_CODE';
2612: l_pk_value := p_complete_rec.default_uom_code;
2613: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2614: l_additional_where_clause := ' uom_class = '''||p_complete_rec.uom_type||'''';