DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on MTL_UNITS_OF_MEASURE_TL

Line 1295: FROM mtl_units_of_measure_tl

1291: WHERE fndLkups.lookup_code = p_period_unit
1292: and fndLkups.lookup_type = 'EGO_SRV_DURATION_PERIOD';*/
1293: /*Bug #6140663 - fp of 6026318*/
1294: SELECT unit_of_measure_tl
1295: FROM mtl_units_of_measure_tl
1296: WHERE uom_code = p_period_unit
1297: AND language = userenv('LANG');
1298:
1299: CURSOR cntrct_hdr_addr_bill_to_cur(p_contract_id NUMBER)

Line 2588: FROM mtl_units_of_measure_tl

2584: CURSOR covered_level_period_cur(p_period_unit VARCHAR)
2585: IS
2586: /*Bug #6140663 - fp of 6026318*/
2587: SELECT unit_of_measure_tl
2588: FROM mtl_units_of_measure_tl
2589: WHERE uom_code = p_period_unit
2590: AND language = userenv('LANG');
2591:
2592: /*SELECT fndLkups.meaning

Line 3411: mtl_units_of_measure_tl mtl,

3407: bsh.PERCENT_OVER_LIST_PRICE
3408:
3409: FROM oks_billrate_schedules bsh ,
3410: okc_k_lines_b lines,
3411: mtl_units_of_measure_tl mtl,
3412: fnd_lookups fnd
3413: WHERE bsh.cle_id = lines.id
3414: and lines.lse_id in (6,24,60)
3415: and lines.cle_id = p_bill_type_id

Line 3747: MTL_UNITS_OF_MEASURE_TL mtl

3743: OKS_K_LINES_B rul,
3744: OKC_K_LINES_V okcLnV,
3745: OKS_K_LINES_V oksLnV,
3746: OKC_K_ITEMS okcItms,
3747: MTL_UNITS_OF_MEASURE_TL mtl
3748: WHERE sub_line.cle_id = to_number(p_line_id_arg)
3749: AND rul.cle_id = sub_line.id
3750: AND okcLnV.cle_id = sub_line.cle_id
3751: AND oksLnV.cle_id = sub_line.id