DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 556: ,mtl_units_of_measure_tl tl

552: Cursor qty_uom_csr_sub(p_cle_id Number) Is
553: SELECT okc.Number_of_items
554: ,tl.Unit_of_measure uom_code
555: FROM okc_k_items okc
556: ,mtl_units_of_measure_tl tl
557: WHERE okc.cle_id = p_cle_id
558: AND tl.uom_code = okc.uom_code
559: AND tl.language = USERENV('LANG');
560:

Line 1480: ,mtl_units_of_measure_tl tl

1476: Cursor qty_uom_csr(p_cle_id Number) Is
1477: SELECT okc.Number_of_items
1478: ,tl.Unit_of_measure uom_code
1479: FROM okc_k_items okc
1480: ,mtl_units_of_measure_tl tl
1481: WHERE okc.cle_id = p_cle_id
1482: AND tl.uom_code = okc.uom_code
1483: AND tl.language = USERENV('LANG');
1484:

Line 2366: ,mtl_units_of_measure_tl tl

2362: Cursor qty_uom_csr(p_cle_id Number) Is
2363: SELECT okc.Number_of_items
2364: ,tl.Unit_of_measure uom_code
2365: FROM okc_k_items okc
2366: ,mtl_units_of_measure_tl tl
2367: WHERE okc.cle_id = p_cle_id
2368: AND tl.uom_code = okc.uom_code
2369: AND tl.language = USERENV('LANG');
2370: