APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_UNITS_OF_MEASURE_TL

Line 162: mtl_units_of_measure_tl m

158: INTO
159: p_amount_based_uom,
160: p_amount_based_unit_of_measure
161: FROM
162: mtl_units_of_measure_tl m
163: ,pon_party_preferences p
164: WHERE
165: p.PARTY_ID = p_trading_partner_id
166: and PREFERENCE_NAME = 'AMOUNT_BASED_UOM'

Line 2244: mtl_units_of_measure_tl uom

2240: msi.allow_item_desc_update_flag,
2241: decode(p1.unit_of_measure, 'UOM_NONE_ENTERED', uom.unit_of_measure_tl, p1.unit_of_measure)
2242: from mtl_system_items_kfv msi,
2243: mtl_system_items_tl msitl,
2244: mtl_units_of_measure_tl uom
2245: where msi.concatenated_segments = p1.item_number and
2246: msi.organization_id = l_inventory_org_id and
2247: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and
2248: msi.purchasing_enabled_flag = 'Y' and

Line 2694: -- Unit of Measure must be valid in mtl_units_of_measure_tl

2690: AND batch_id = p_batch_id
2691: and group_type <> 'GROUP'
2692: AND Nvl(clm_info_flag,'N') <> 'Y';
2693: --
2694: -- Unit of Measure must be valid in mtl_units_of_measure_tl
2695: --
2696: -- Some modifications to avoid full table scan and more imp
2697: -- to incorporate the new demand in bug 2319969
2698: update pon_item_prices_interface p

Line 2700: mtl_units_of_measure_tl m

2696: -- Some modifications to avoid full table scan and more imp
2697: -- to incorporate the new demand in bug 2319969
2698: update pon_item_prices_interface p
2699: set uom_code = (select nvl(max(uom_code),'XXX') from
2700: mtl_units_of_measure_tl m
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

Line 2713: mtl_units_of_measure_tl m

2709: and unit_of_measure <> 'UOM_NONE_ENTERED';
2710: --
2711: update pon_item_prices_interface p
2712: set uom_code = (select nvl(max(uom_code),'XXX') from
2713: mtl_units_of_measure_tl m
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

Line 2727: mtl_units_of_measure_tl m

2723: and uom_code = 'XXX';
2724: --
2725: update pon_item_prices_interface p
2726: set uom_code = (select nvl(max(uom_code),'XXX') from
2727: mtl_units_of_measure_tl m
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

Line 2741: mtl_units_of_measure_tl m

2737: and uom_code = 'XXX';
2738: --
2739: update pon_item_prices_interface p
2740: set uom_code = (select nvl(max(uom_code),'XXX') from
2741: mtl_units_of_measure_tl m
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

Line 2760: mtl_units_of_measure_tl m

2756: -- we need to update all valid user entered unit of measures to the
2757: -- actual case sensitive value
2758: update pon_item_prices_interface p
2759: set unit_of_measure = (select nvl(max(unit_of_measure_tl),p.unit_of_measure) from
2760: mtl_units_of_measure_tl m
2761: where language = p_language
2762: and uom_code = p.uom_code)
2763: where batch_id = p_batch_id
2764: and unit_of_measure <> 'UOM_NONE_ENTERED'