APPS.OKS_BILL_REC_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 365: ,mtl_units_of_measure_tl tl

361: Cursor qty_uom_csr(p_cle_id IN NUMBER) Is
362: SELECT okc.Number_of_items
363: ,tl.Unit_of_measure uom_code
364: FROM okc_k_items OKC
365: ,mtl_units_of_measure_tl tl
366: WHERE okc.cle_id = P_cle_id
367: AND tl.uom_code = OKC.uom_code
368: AND tl.language = USERENV('LANG');
369:

Line 2896: ,mtl_units_of_measure_tl tl

2892: Cursor qty_uom_csr(p_cle_id Number) Is
2893: SELECt okc.Number_of_items
2894: ,tl.Unit_of_measure uom_code
2895: FROM OKC_K_ITEMS OKC
2896: ,mtl_units_of_measure_tl tl
2897: WHERE okc.cle_id = P_cle_id
2898: AND tl.uom_code = OKC.uom_code
2899: AND tl.language = USERENV('LANG');
2900:

Line 7855: mtl_units_of_measure_tl tl

7851: Is
7852: Select okc.Number_of_items,
7853: tl.Unit_of_measure uom_code
7854: From OKC_K_ITEMS_V OKC,
7855: mtl_units_of_measure_tl tl
7856: Where okc.cle_id = P_cle_id
7857: And tl.uom_code = OKC.uom_code
7858: AND tl.language = USERENV('LANG');
7859:

Line 10917: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

10913: /*Declaration Section*/
10914: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
10915: is
10916: SELECT 1
10917: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
10918: WHERE TL.uom_code = okc.uom_code
10919: AND TL.uom_code = p_uom_code
10920: --AND TL.uom_class = 'Time' commented for bug#5585356
10921: AND okc.active_flag = 'Y'

Line 11043: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

11039: /*Declaration Section*/
11040: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
11041: is
11042: SELECT 1
11043: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
11044: WHERE TL.uom_code = okc.uom_code
11045: AND TL.uom_code = p_uom_code
11046: --AND TL.uom_class = 'Time' commented for bug#5585356
11047: AND okc.active_flag = 'Y'