APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_PROFILE

Line 2502: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))

2498: and (p.purchase_basis <> 'TEMP LABOR' or
2499: (p.purchase_basis = 'TEMP LABOR' and
2500: exists (select 1 from mtl_uom_conversions_val_v where
2501: m.unit_of_measure = unit_of_measure and
2502: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2503: where batch_id = p_batch_id
2504: and unit_of_measure <> 'UOM_NONE_ENTERED';
2505: --
2506: update pon_item_prices_interface p

Line 2515: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))

2511: and (p.purchase_basis <> 'TEMP LABOR' or
2512: (p.purchase_basis = 'TEMP LABOR' and
2513: exists (select 1 from mtl_uom_conversions_val_v where
2514: m.unit_of_measure = unit_of_measure and
2515: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2516: where batch_id = p_batch_id
2517: and unit_of_measure <> 'UOM_NONE_ENTERED'
2518: and uom_code = 'XXX';
2519: --

Line 2529: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))

2525: and (p.purchase_basis <> 'TEMP LABOR' or
2526: (p.purchase_basis = 'TEMP LABOR' and
2527: exists (select 1 from mtl_uom_conversions_val_v where
2528: m.unit_of_measure = unit_of_measure and
2529: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2530: where batch_id = p_batch_id
2531: and unit_of_measure <> 'UOM_NONE_ENTERED'
2532: and uom_code = 'XXX';
2533: --

Line 2543: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))

2539: and (p.purchase_basis <> 'TEMP LABOR' or
2540: (p.purchase_basis = 'TEMP LABOR' and
2541: exists (select 1 from mtl_uom_conversions_val_v where
2542: m.unit_of_measure = unit_of_measure and
2543: uom_class = FND_PROFILE.VALUE('PO_RATE_UOM_CLASS')))))
2544: where batch_id = p_batch_id
2545: and unit_of_measure <> 'UOM_NONE_ENTERED'
2546: and uom_code = 'XXX';
2547: