APPS.OKS_BILL_REC_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 362: ,mtl_units_of_measure_tl tl

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

Line 2882: ,mtl_units_of_measure_tl tl

2878: Cursor qty_uom_csr(p_cle_id Number) Is
2879: SELECt okc.Number_of_items
2880: ,tl.Unit_of_measure uom_code
2881: FROM OKC_K_ITEMS OKC
2882: ,mtl_units_of_measure_tl tl
2883: WHERE okc.cle_id = P_cle_id
2884: AND tl.uom_code = OKC.uom_code
2885: AND tl.language = USERENV('LANG');
2886:

Line 7823: mtl_units_of_measure_tl tl

7819: Is
7820: Select okc.Number_of_items,
7821: tl.Unit_of_measure uom_code
7822: From OKC_K_ITEMS_V OKC,
7823: mtl_units_of_measure_tl tl
7824: Where okc.cle_id = P_cle_id
7825: And tl.uom_code = OKC.uom_code
7826: AND tl.language = USERENV('LANG');
7827:

Line 10768: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

10764: /*Declaration Section*/
10765: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
10766: is
10767: SELECT 1
10768: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
10769: WHERE TL.uom_code = okc.uom_code
10770: AND TL.uom_code = p_uom_code
10771: --AND TL.uom_class = 'Time' commented for bug#5585356
10772: AND okc.active_flag = 'Y'

Line 10894: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc

10890: /*Declaration Section*/
10891: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
10892: is
10893: SELECT 1
10894: FROM MTL_UNITS_OF_MEASURE_TL TL, okc_time_code_units_v okc
10895: WHERE TL.uom_code = okc.uom_code
10896: AND TL.uom_code = p_uom_code
10897: --AND TL.uom_class = 'Time' commented for bug#5585356
10898: AND okc.active_flag = 'Y'