DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 639: ,mtl_units_of_measure_tl tl

635: Cursor qty_uom_csr_sub(p_cle_id Number) Is
636: SELECT okc.Number_of_items
637: ,tl.Unit_of_measure uom_code
638: FROM okc_k_items okc
639: ,mtl_units_of_measure_tl tl
640: WHERE okc.cle_id = p_cle_id
641: AND tl.uom_code = okc.uom_code
642: AND tl.language = USERENV('LANG');
643:

Line 3660: ,mtl_units_of_measure_tl tl

3656: Cursor qty_uom_csr_sub(p_cle_id Number) Is
3657: SELECT okc.Number_of_items
3658: ,tl.Unit_of_measure uom_code
3659: FROM okc_k_items okc
3660: ,mtl_units_of_measure_tl tl
3661: WHERE okc.cle_id = p_cle_id
3662: AND tl.uom_code = okc.uom_code
3663: AND tl.language = USERENV('LANG');
3664:

Line 4613: ,mtl_units_of_measure_tl tl

4609: Cursor qty_uom_csr(p_cle_id Number) Is
4610: SELECT okc.Number_of_items
4611: ,tl.Unit_of_measure uom_code
4612: FROM okc_k_items okc
4613: ,mtl_units_of_measure_tl tl
4614: WHERE okc.cle_id = p_cle_id
4615: AND tl.uom_code = okc.uom_code
4616: AND tl.language = USERENV('LANG');
4617:

Line 5427: ,mtl_units_of_measure_tl tl

5423: Cursor qty_uom_csr(p_cle_id Number) Is
5424: SELECT okc.Number_of_items
5425: ,tl.Unit_of_measure uom_code
5426: FROM okc_k_items okc
5427: ,mtl_units_of_measure_tl tl
5428: WHERE okc.cle_id = p_cle_id
5429: AND tl.uom_code = okc.uom_code
5430: AND tl.language = USERENV('LANG');
5431: