APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_UOM_CONVERSIONS_VAL_V

Line 2705: exists (select 1 from mtl_uom_conversions_val_v where

2701: where language = p_language
2702: and unit_of_measure_tl = p.unit_of_measure
2703: and (p.purchase_basis <> 'TEMP LABOR' or
2704: (p.purchase_basis = 'TEMP LABOR' and
2705: exists (select 1 from mtl_uom_conversions_val_v where
2706: m.unit_of_measure = unit_of_measure and
2707: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2708: where batch_id = p_batch_id
2709: and unit_of_measure <> 'UOM_NONE_ENTERED';

Line 2718: exists (select 1 from mtl_uom_conversions_val_v where

2714: where language = p_language
2715: and upper(unit_of_measure_tl) = upper(p.unit_of_measure)
2716: and (p.purchase_basis <> 'TEMP LABOR' or
2717: (p.purchase_basis = 'TEMP LABOR' and
2718: exists (select 1 from mtl_uom_conversions_val_v where
2719: m.unit_of_measure = unit_of_measure and
2720: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2721: where batch_id = p_batch_id
2722: and unit_of_measure <> 'UOM_NONE_ENTERED'

Line 2732: exists (select 1 from mtl_uom_conversions_val_v where

2728: where language = p_language
2729: and uom_code = p.unit_of_measure
2730: and (p.purchase_basis <> 'TEMP LABOR' or
2731: (p.purchase_basis = 'TEMP LABOR' and
2732: exists (select 1 from mtl_uom_conversions_val_v where
2733: m.unit_of_measure = unit_of_measure and
2734: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2735: where batch_id = p_batch_id
2736: and unit_of_measure <> 'UOM_NONE_ENTERED'

Line 2746: exists (select 1 from mtl_uom_conversions_val_v where

2742: where language = p_language
2743: and upper(uom_code) = upper(p.unit_of_measure)
2744: and (p.purchase_basis <> 'TEMP LABOR' or
2745: (p.purchase_basis = 'TEMP LABOR' and
2746: exists (select 1 from mtl_uom_conversions_val_v where
2747: m.unit_of_measure = unit_of_measure and
2748: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2749: where batch_id = p_batch_id
2750: and unit_of_measure <> 'UOM_NONE_ENTERED'