DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on INV_CONVERT

Line 5904: inv_convert.inv_um_conversion(p_from_uom_code,

5900: NULL;
5901: END;
5902:
5903: IF (p_from_uom_code <> l_primary_uom_code) THEN
5904: inv_convert.inv_um_conversion(p_from_uom_code,
5905: l_primary_uom_code,
5906: p_item_id,
5907: l_conversion_rate);
5908: ELSE

Line 6146: inv_convert.inv_um_conversion(p_from_uom_code,

6142: mydebug('get_converson_rate function value of l_sec_uom_code is :'|| l_sec_uom_code);
6143: mydebug('get_converson_rate function value of p_from_uom_code is :'|| p_from_uom_code);
6144: IF p_fulfillment_base = 'S' THEN -- MUOM:SK
6145: IF (p_from_uom_code <> l_sec_uom_code) THEN
6146: inv_convert.inv_um_conversion(p_from_uom_code,
6147: l_sec_uom_code,
6148: p_item_id,
6149: l_conversion_rate);
6150: ELSE

Line 6155: inv_convert.inv_um_conversion(p_from_uom_code,

6151: l_conversion_rate := 1;
6152: END IF;
6153: ELSE -- MUOM:SK
6154: IF (p_from_uom_code <> l_primary_uom_code) THEN
6155: inv_convert.inv_um_conversion(p_from_uom_code,
6156: l_primary_uom_code,
6157: p_item_id,
6158: l_conversion_rate);
6159: ELSE

Line 6216: AND inv_convert.is_uom_in_same_class( Substr(uom_code_comp, 1, Instr(uom_code_comp, '(') - 1), p_organization_id , p_item_id , Nvl(p_fulfillment_base,'P')) = 'Y')

6212: AND inventory_item_id = p_item_id
6213: AND Nvl(uom_type, 3) = Nvl(p_uom_type, 3)
6214: AND uom_code LIKE ( l_code ))
6215: WHERE ((Nvl(p_fulfillment_base,'P') = 'S'
6216: AND inv_convert.is_uom_in_same_class( Substr(uom_code_comp, 1, Instr(uom_code_comp, '(') - 1), p_organization_id , p_item_id , Nvl(p_fulfillment_base,'P')) = 'Y')
6217: OR (Nvl(p_fulfillment_base,'P') = 'P'))
6218: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.Get_conversion_rate(Substr(uom_code_comp, 1,
6219: Instr(uom_code_comp, '(') - 1),
6220: p_organization_id,