APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_UNITS_OF_MEASURE_TL

Line 148: mtl_units_of_measure_tl m

144: INTO
145: p_amount_based_uom,
146: p_amount_based_unit_of_measure
147: FROM
148: mtl_units_of_measure_tl m
149: ,pon_party_preferences p
150: WHERE
151: p.PARTY_ID = p_trading_partner_id
152: and PREFERENCE_NAME = 'AMOUNT_BASED_UOM'

Line 2054: mtl_units_of_measure_tl uom

2050: msi.allow_item_desc_update_flag,
2051: decode(p1.unit_of_measure, 'UOM_NONE_ENTERED', uom.unit_of_measure_tl, p1.unit_of_measure)
2052: from mtl_system_items_kfv msi,
2053: mtl_system_items_tl msitl,
2054: mtl_units_of_measure_tl uom
2055: where msi.concatenated_segments = p1.item_number and
2056: msi.organization_id = l_inventory_org_id and
2057: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and
2058: msi.purchasing_enabled_flag = 'Y' and

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

2485: AND order_type_lookup_code <> 'FIXED PRICE'
2486: AND batch_id = p_batch_id
2487: and group_type <> 'GROUP';
2488: --
2489: -- Unit of Measure must be valid in mtl_units_of_measure_tl
2490: --
2491: -- Some modifications to avoid full table scan and more imp
2492: -- to incorporate the new demand in bug 2319969
2493: update pon_item_prices_interface p

Line 2495: mtl_units_of_measure_tl m

2491: -- Some modifications to avoid full table scan and more imp
2492: -- to incorporate the new demand in bug 2319969
2493: update pon_item_prices_interface p
2494: set uom_code = (select nvl(max(uom_code),'XXX') from
2495: mtl_units_of_measure_tl m
2496: where language = p_language
2497: and unit_of_measure_tl = p.unit_of_measure
2498: and (p.purchase_basis <> 'TEMP LABOR' or
2499: (p.purchase_basis = 'TEMP LABOR' and

Line 2508: mtl_units_of_measure_tl m

2504: and unit_of_measure <> 'UOM_NONE_ENTERED';
2505: --
2506: update pon_item_prices_interface p
2507: set uom_code = (select nvl(max(uom_code),'XXX') from
2508: mtl_units_of_measure_tl m
2509: where language = p_language
2510: and upper(unit_of_measure_tl) = upper(p.unit_of_measure)
2511: and (p.purchase_basis <> 'TEMP LABOR' or
2512: (p.purchase_basis = 'TEMP LABOR' and

Line 2522: mtl_units_of_measure_tl m

2518: and uom_code = 'XXX';
2519: --
2520: update pon_item_prices_interface p
2521: set uom_code = (select nvl(max(uom_code),'XXX') from
2522: mtl_units_of_measure_tl m
2523: where language = p_language
2524: and uom_code = p.unit_of_measure
2525: and (p.purchase_basis <> 'TEMP LABOR' or
2526: (p.purchase_basis = 'TEMP LABOR' and

Line 2536: mtl_units_of_measure_tl m

2532: and uom_code = 'XXX';
2533: --
2534: update pon_item_prices_interface p
2535: set uom_code = (select nvl(max(uom_code),'XXX') from
2536: mtl_units_of_measure_tl m
2537: where language = p_language
2538: and upper(uom_code) = upper(p.unit_of_measure)
2539: and (p.purchase_basis <> 'TEMP LABOR' or
2540: (p.purchase_basis = 'TEMP LABOR' and

Line 2555: mtl_units_of_measure_tl m

2551: -- we need to update all valid user entered unit of measures to the
2552: -- actual case sensitive value
2553: update pon_item_prices_interface p
2554: set unit_of_measure = (select nvl(max(unit_of_measure_tl),p.unit_of_measure) from
2555: mtl_units_of_measure_tl m
2556: where language = p_language
2557: and uom_code = p.uom_code)
2558: where batch_id = p_batch_id
2559: and unit_of_measure <> 'UOM_NONE_ENTERED'