APPS.OKS_TIME_MEASURES_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 99

select uom_code
from OKC_TIME_CODE_UNITS_V
where  tce_code = cp_tce_code and quantity = cp_quantity
and active_flag = 'Y';

Line: 146

 SELECT 1
 FROM okx_units_of_measure_v
 WHERE uom_code = p_uom_code;

Line: 516

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 AND LANGUAGE = USERENV('LANG');

Line: 527

SELECT tce_code
FROM OKC_TIME_CODE_UNITS_B
WHERE uom_code=p_uom_code;

Line: 658

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 --AND   uom_class = 'Time' commented for bug#5585356
 AND LANGUAGE = USERENV('LANG');

Line: 816

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 --AND   uom_class = 'Time'  commented for bug#5585356
 AND LANGUAGE = USERENV('LANG');

Line: 958

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 --AND   uom_class = 'Time'  commented for bug#5585356
 AND LANGUAGE = USERENV('LANG');

Line: 1113

 SELECT 1
 FROM MTL_UNITS_OF_MEASURE_TL
 WHERE uom_code = p_uom_code
 --AND   uom_class = 'Time'  commented for bug#5585356
 AND LANGUAGE = USERENV('LANG');

Line: 1319

  SELECT tce_code,quantity
  FROM okc_time_code_units_b
  WHERE uom_code = p_source_uom
  AND tce_code in (SELECT tce_code FROM okc_time_code_units_b WHERE uom_code=p_target_uom)
  ORDER BY quantity ASC;

Line: 1327

  SELECT  quantity
  FROM okc_time_code_units_b
  WHERE  tce_code = p_source_uom
  AND    active_flag = 'Y'
  AND    uom_code = p_target_uom;