DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on INV_UI_ITEM_LOVS

Line 3718: SELECT inv_ui_item_lovs.get_conversion_rate (oel.order_quantity_uom,

3714: IF l_count = 1
3715: THEN
3716: l_progress := '30';
3717: BEGIN
3718: SELECT inv_ui_item_lovs.get_conversion_rate (oel.order_quantity_uom,
3719: p_organization_id,
3720: --oel.ordered_item_id) -- commented for Bug 12640725
3721: oel.inventory_item_id) -- added for Bug 12640725
3722: INTO x_uom_code

Line 3812: SELECT inv_ui_item_lovs.get_conversion_rate (mum.uom_code, p_organization_id, rsl.item_id)

3808: IF l_count = 1
3809: THEN
3810: l_progress := '30';
3811: BEGIN
3812: SELECT inv_ui_item_lovs.get_conversion_rate (mum.uom_code, p_organization_id, rsl.item_id)
3813: INTO x_uom_code
3814: FROM rcv_shipment_lines rsl, mtl_units_of_measure mum
3815: WHERE rsl.shipment_header_id = p_shipment_header_id
3816: AND rsl.unit_of_measure IS NOT NULL

Line 4103: SELECT inv_ui_item_lovs.get_conversion_rate(mum.uom_code,

4099:
4100: IF l_count = 1 THEN
4101: l_progress := '30';
4102: BEGIN
4103: SELECT inv_ui_item_lovs.get_conversion_rate(mum.uom_code,
4104: p_organization_id,
4105: pol.item_id)
4106: INTO x_uom_code
4107: FROM po_lines pol

Line 8186: x_uom_code := inv_ui_item_lovs.get_conversion_rate

8182: l_uom_code := NULL;
8183: END;
8184:
8185: IF (l_uom_code IS NOT NULL) THEN
8186: x_uom_code := inv_ui_item_lovs.get_conversion_rate
8187: (l_uom_code,
8188: p_organization_id,
8189: p_item_id);
8190: ELSE