APPS.INV_CONVERT dependencies on INV_UI_ITEM_LOVS

Line 1076: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id)

1072: END IF;
1073:
1074: if (p_loc_id IS NOT NULL) THEN
1075: begin
1076: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id)
1077: INTO l_loc_uom, l_uom_string
1078: FROM mtl_item_locations
1079: WHERE organization_id = p_org_id
1080: AND subinventory_code = p_sub_code

Line 1099: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,

1095: end if;
1096:
1097: if (l_loc_uom IS NULL) THEN
1098: begin
1099: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,
1100: p_org_Id,
1101: p_item_Id)
1102: INTO l_loc_uom, l_uom_string
1103: FROM MTL_SECONDARY_INVENTORIES

Line 1207: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id, l_fulfillment_base)

1203: END IF;
1204:
1205: if (p_loc_id IS NOT NULL) THEN
1206: begin
1207: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id, l_fulfillment_base)
1208: INTO l_loc_uom, l_uom_string
1209: FROM mtl_item_locations
1210: WHERE organization_id = p_org_id
1211: AND subinventory_code = p_sub_code

Line 1230: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,

1226: end if;
1227:
1228: if (l_loc_uom IS NULL) THEN
1229: begin
1230: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,
1231: p_org_Id,
1232: p_item_Id,
1233: l_fulfillment_base)
1234: INTO l_loc_uom, l_uom_string