DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_PROFILE

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

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';
2710: --
2711: update pon_item_prices_interface p

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

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'
2723: and uom_code = 'XXX';
2724: --

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

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'
2737: and uom_code = 'XXX';
2738: --

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

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'
2751: and uom_code = 'XXX';
2752: